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
Hello, Would please help me to find the proper formula for this below
if R6 is Action date
if S6 is Target date
T6 is Number of days to close the action ( =S6-R6)
U6 Date of completion or closed action

I want a formula for V6 to be as :
- Open action if date range between R6 and S6
- Over Due if date > S6
- Closed if insert date in U6 cell

Thanks





1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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