I need help with my formula. It is only calculating if there is a completed date entered in the cell. I need it to calculate the number of days remaining and or number of days past the deadline, and I need it to show the calculations once a completed date is entered.
IF(ISDATE(Deadline@row), NETWORKDAY(Complete@row, Deadline@row), NETWORKDAY(TODAY(), Deadline@row))
Columns: Days Remaining, Task, Status, Deadline, Complete
Help Article Resources
Check out the Formula Handbook template!