EOMONTH similar

I am trying to automate the Month/Year field to add one from the pervious cell. Excel formula: =EOMONTH(E13,1)
Is there any work around in smartsheet?

Best Answer

  • NickStaffordPM
    NickStaffordPM ✭✭✭✭✭
    edited 08/28/24 Answer ✓

    Something like below would potentially work for that?

    =((MONTH(DATE(2024, 7, 1)) + 1) + " / " + ((YEAR(DATE(2024, 7, 1))

    If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.

    Thanks!

    Nick Stafford

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!