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

Smartsheet FORM Dropdown List - Cells in Column "have values that aren't dropdown values" Error
Hello All, Specifically for the Form's Dropdown List - what does it mean when I get this error message for a list that has 87 (manual, ugh) entries? —> (14 cells in (form) column) "have values that aren't dropdown values." Are there any special characters that aren't allowed, maybe? What are the rules for text to be valid…
Action item Tracker with 2 way sync for selective items
I would like to manager a Master Action Item Tracker, but there are some items on the list that are confidential. Is there a way for me to create a duplicate of that action tracker for selective rows and for my team and I to colloborate on updating status between the Master and duplicate tracker and have the updates feed…
Need help with a cross-sheet reference formula.
I am trying to create a cross-sheet formula so I can count the number of projects for a specific PM where the show start data is in the month of January and year is 2024. The source sheet contains show start dates that are in 2025 so I want to be able to avoid counting them by mistake. I'm basically trying to count the…