Multiple IF formula in one cell, date comparison
Solved/Closed
She.Charm
Posts
2
Registration date
Tuesday January 31, 2017
Status
Member
Last seen
February 1, 2017
-
Updated by TrowaD on 31/01/17 at 11:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 2, 2017 at 10:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 2, 2017 at 10:37 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
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
Related:
- Multiple IF formula in one cell, date comparison
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How to lasso multiple objects in photoshop - Guide
- Percentage formula in excel marksheet - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 31, 2017 at 11:36 AM
Jan 31, 2017 at 11:36 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
She.Charm
Posts
2
Registration date
Tuesday January 31, 2017
Status
Member
Last seen
February 1, 2017
1
Feb 1, 2017 at 03:07 AM
Feb 1, 2017 at 03:07 AM
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"))
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"))
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 2, 2017 at 10:37 AM
Feb 2, 2017 at 10:37 AM
All you needed was a push in the right direction. Good to see you worked it out.