Multiple IF formula in one cell, date comparison [Solved/Closed]

Report
Posts
2
Registration date
Tuesday January 31, 2017
Status
Member
Last seen
February 1, 2017
-
Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
-
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

2 replies

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Tuesday January 31, 2017
Status
Member
Last seen
February 1, 2017
1
Dear Trowa

Thanks and appreciated, but sorry that formula did not work still give me wrong message.

I Tried before many times ,and now I solved it finally by using this formula:

=IF(U6<>"","Closed",IF(AND(R6<=TODAY(),S6>=TODAY()),"Open","Overdue"))
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
All you needed was a push in the right direction. Good to see you worked it out.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!