Date Formula for Xth Day of the Month

Hi there! I'm hoping for a formula that returns the third working date of the month. I do have dependencies enabled, but none of my dependencies stem from this row. Seeing as how others will use this sheet monthly, it would be nice if rows like this autofilled monthly to avoid some manual work.

In my dependencies, I have put in non working days and holidays so I don't know if the formula provided needs to take "working" day into account. Thanks so much!

Answers

  • Parker Oxford
    Parker Oxford ✭✭✭✭✭

    Are you simply wanting it to display the 3rd day of the current month? If so, see the below formula:

    =DATE(YEAR(TODAY()), MONTH(TODAY()), 3)
    


    ( @ me in the replies or I'll lose your response! )

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!