Display negative for past days and positive for upcoming days

Michael Macygin

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.

David Tutwiler

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 Tutwiler

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

Michael Macygin

David, thanks so much. This fixed my issue perfectly. I truly appreciate your assistance!

David Tutwiler

No problem. Glad you got it working.