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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!