If Date
Closed
Ahmed Dagh
-
Jan 31, 2017 at 09:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 31, 2017 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 31, 2017 at 11:35 AM
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 31, 2017 at 11:35 AM
Jan 31, 2017 at 11:35 AM
Hi Ahmed,
Try the following formula:
=IF(U6<>"","Closed",IF(TODAY()>S6,"Over Due",IF(AND(TODAY()<S6,TODAY()>R6),"Open Action","")))
Best regards,
Trowa
Try the following formula:
=IF(U6<>"","Closed",IF(TODAY()>S6,"Over Due",IF(AND(TODAY()<S6,TODAY()>R6),"Open Action","")))
Best regards,
Trowa