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

She.Charm 2 Posts Tuesday January 31, 2017Registration date February 1, 2017 Last seen - Jan 31, 2017 at 09:56 AM - Latest reply: TrowaD 2395 Posts Sunday September 12, 2010Registration date July 17, 2018 Last seen
- 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
See more 

3 replies

Best answer
TrowaD 2395 Posts Sunday September 12, 2010Registration date July 17, 2018 Last seen - Jan 31, 2017 at 11:36 AM
1
Thank you
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

Thank you, TrowaD 1

Something to say? Add comment

CCM has helped 1701 users this month

Best answer
She.Charm 2 Posts Tuesday January 31, 2017Registration date February 1, 2017 Last seen - Feb 1, 2017 at 03:07 AM
1
Thank you
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"))

Thank you, She.Charm 1

Something to say? Add comment

CCM has helped 1701 users this month

TrowaD 2395 Posts Sunday September 12, 2010Registration date July 17, 2018 Last seen - Feb 2, 2017 at 10:37 AM
All you needed was a push in the right direction. Good to see you worked it out.