Can someone help me with a date formula?
I have a column that shows how many days have passed since a start date. I would like to add a column with an end date, and if there is an end date, have that count stop.
So if the end date is blank, the count will keep going up. If the end date is entered, it will show how many days passed between the start date and the end date.
Pretty straightforward I think, but please let me know if I can answer any questions!
Tags:
Answers
-
=IF([Start Date]@row = "", "", IF([End Date]@row = "", NETDAYS([Start Date]@row, TODAY()), NETDAYS([Start Date]@row, [End Date]@row))
This should help you out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 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!