Tracking the status of project-excel

问题:

I am trying to track the status of a project: I have 4 columns each with date format. A status column which would show "OVERDUE" if the date in column A is over 12 days. "CURRENT" if less than 12 days. However, if a date is entered in column D the status would show "COMPLETE".

I am very new at this, thanks for any help!

回答1:

=IF(D1="",
IF(A1-NOW>12,"OVERDUE","CURRENT"),
IF(CELL("Format",D1)="D1","COMPLETE",
IF(A1-NOW>12,"OVERDUE","CURRENT"))

Let me know if you want some indicator for whether a value is entered in D and is not in the correct format.