Display negative for past days and positive for upcoming days
I've got a sheet with a "Start" column and a "Today" column. I want this formula;
=NETDAYS(Start25, TODAY25)
To display the number of days as a negative if the Start was prior to TODAY or as a positive if the Start is after TODAY.
Currently, my displayed results are opposite to that.
Best Answer
-
You should be able to just add a - before the statement. Also, I found in testing that to get a true date you have to add a +1, otherwise the same day will give you a value of 1 or -1. Below is the formula I got to work.
=-NETDAYS(Start@row, Today@row) + 1
Answers
-
You should be able to just add a - before the statement. Also, I found in testing that to get a true date you have to add a +1, otherwise the same day will give you a value of 1 or -1. Below is the formula I got to work.
=-NETDAYS(Start@row, Today@row) + 1
-
David, thanks so much. This fixed my issue perfectly. I truly appreciate your assistance!
-
No problem. Glad you got it working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!