If Statement with today's date minus due date for a delay calculation

**RDFUC** · 06-26-2013, 02:34 PM

Hello all,

I need your help with an IF Statement to show delays in number of days. What I have so far-

=IF(F2="Complete","None",IF(F2="In Progress", "InProgressStatus", IF(F2="On Hold", "On HoldStatus", IF(F2="Not Started", "NotStartedStatus", IF(F2="Not Required", "")))))

What I want to happen is when F2=In Progress, excel goes takes the current date, subtracts the due date (given in a cell) and displays a number in days that represents the delay.

=DAYS360(>>DueDateCell<<,TODAY()) works in a separate cell but not in the statement.

Does that make sense? TIA

**Ace_XL** · 06-26-2013, 02:37 PM

Try

=IF(F2="Complete","None",IF(F2="In Progress",DAYS360(>>DueDateCell<<,TODAY()), IF(F2="On Hold", "On HoldStatus", IF(F2="Not Started", "NotStartedStatus", IF(F2="Not Required", "")))))

This will replace the "InProgressStatus" to the delay in days