Days to go formula
I have a dedicated column "days to go" I'm trying to get the formula to take the networkdays between today and the start date (accounting for dates in the "holiday helper" column.
This formula works but gives a negative number. If the date is 5 days in the future I'd like it to read 5 not -5. If in the past be negative, not a positive number. But i can't seem to tweak this formula to achieve that. Appreciate help, thanks!
=IFERROR(IF([Start Date]@row = "", NETWORKDAYS([Start Date]@row, TODAY()), NETWORKDAYS([Start Date]@row, TODAY(), [Holiday Helper]:[Holiday Helper])), "")
Best Answer
-
You could swap the start date and end date, so rather than days from Start Date to today, do today to Start date
=IFERROR(IF([Start Date]@row = "", NETWORKDAYS(TODAY(),[Start Date]@row), NETWORKDAYS(TODAY(), [Start Date]@row, [Holiday Helper]:[Holiday Helper])), "")
Does that help?
Answers
-
You could swap the start date and end date, so rather than days from Start Date to today, do today to Start date
=IFERROR(IF([Start Date]@row = "", NETWORKDAYS(TODAY(),[Start Date]@row), NETWORKDAYS(TODAY(), [Start Date]@row, [Holiday Helper]:[Holiday Helper])), "")
Does that help?
-
I thought it should be that easy - I kept getting an #UNPARSEABLE when swapped the TODAY() and the [Start Date]@row. I realize now with your help, there should not be a ) after the last [Start Date]@row So, I had one " ) " too many. Thanks!
-
Happy to help @Angela.R - glad you got there.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!