Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How to get EOM (end of month)?

Shawn1

Shawn1 ✭

10/16/16 edited 12/09/19 in Archived 2016 Posts

How do I get the EOM (end of month) if my start date is 10/07/2016 ? I'm new and having some trouble with this. Thanks.

Tags:

0 ·

Comments

Matt Hines ✭

10/17/16

You should be able to use this formula.

=IF(MONTH(Date4) < 12, DATE(YEAR(Date4), MONTH(Date4) + 1, 1) - 1, DATE(YEAR(Date4), 12, 31))

0 · Share on Facebook Share on Twitter
Shawn1 ✭

10/17/16

That got me going. Thank you Matt.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

"Record a Date" Automation to a Cell in a Hidden Column
I have lots of sheets for a reviewing process - each item to review has a new sheet from a template. Each sheet has about 30 rows and a summary sheet. I have an automation that does the following: When "status" cell changes, request an approval. (This is calculated in a summary sheet and written to a cell.) Approval comes…
How to share WorkApps with view only colleagues on an enterprise plan?
Hello! We have an enterprise plan for our company and with 2 licenses on it. I have created a workapp to share some sheets and share a dashboard in one place. Yet I am not sure why I got this message from them when they tried to access it. Could you please help as from my understanding this should be free on the plan we…
How to update certain cells in column based on one cell's input and other column's same ID #?
I have a very simple test script testing tracker located here: I want to be able to do one of the following: 1. Update the Status column for all testers with the same test ID to "Duplicate" once one person tests and puts "FAIL" in the PASS/FAIL column. 2. Do not copy defects to defect tracker sheet if one of the rows with…