Countdown for days until due but stop counting after due date has passed
Hiya, I am trying to write a formula that will count the number of days until a task is due but will not start showing negative numbers once the due date has gone by. I came up with
=NETWORKDAY([Today's Date]@row, [Date Next Check/Validation Due]@row)
But couldn't figure out how to make it be blank once the Date Next Check/Validation Due date passed.
I am also going to have a complementary column with a formula that counts how many days overdue it is, but would like it to be blank until it is actually overdue. I originally thought I could simply take the above formula and swap the column names, but it gave me negative values.
I've fiddled around with incorporating IF formulas but haven't had any luck.
Thanks for any suggestions y'all can come up with :)
Help Article Resources
Check out the Formula Handbook template!