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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!