Im looking for a formula to produce the date of the next upcoming first of the month

Options
BriannaRocamora
BriannaRocamora ✭✭✭
edited 07/10/24 in Formulas and Functions

If todays 7/10, then the next would be 8/1, if today is 8/1 then 9/1

Answers

  • NickStaffordPM
    NickStaffordPM ✭✭✭✭✭
    Options

    Hey Brianna, the following should do the trick, while may not be perfect.

    =DATE(YEAR(TODAY()), MONTH(COLUMN WITH DATE), 1) + 30

    Ensure the COLUMN WITH DATE is the 7/10 you referenced in your orginal question

    Essentially you isolating the month from a date, making it the first of that month in date form, then adding 30 days to move the date forward a month…

    Let me know if this worked!

    Thanks!

    Nick Stafford

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!