跟踪project-excel的状态 [英] Tracking the status of project-excel

问题描述

我正在尝试跟踪项目的状态：我有4列每个日期格式。如果列A中的日期超过12天，则会显示OVERDUE的状态列。 CURRENT如果不到12天。但是，如果在D列中输入日期，状态将显示COMPLETE。

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".

我非常新，
感谢任何帮助！ / p>

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

推荐答案

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

如果您想要一些指示符是否输入值，请告诉我们D并且格式不正确。

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

这篇关于跟踪project-excel的状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！