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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!