本文介绍了跟踪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的状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！