Excel formula - Add days to date based on drop down selection [Solved/Closed]

Report
Posts
2
Registration date
Tuesday August 15, 2017
Status
Member
Last seen
August 17, 2017
-
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want cell C7 to add 90 days to the date in cell C6. But if "Extended New Hire" is reflected in cell C5, I want cell C7 to add 180 days to the date in cell C6. I am able to do


For one option, this formula works in cell C7:

=IF(C5="New Hire",$C$6+90)

I tried formula in cell C7 to adjust based on the text in cell C5, but it is returning a FALSE value instead:

=IF(OR(C5="New Hire",$C$6+90),IF(C5="Post New Hire",$C$6+90),IF(C5="Extended New Hire",$C$6+180))

Any ideas or help would be greatly appreciated :)

2 replies

Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
Sabernethy, Good morning.

Try to use:

=IF(OR(C5="New Hire",C5="Post New Hire"),$C$6+90,IF(C5="Extended New Hire",$C$6+180,"")

Please, tell us if it works as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
2
Registration date
Tuesday August 15, 2017
Status
Member
Last seen
August 17, 2017

That did the trick!!! Thank you so much for the solution here
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
Sabernethy, Good afternoon.

Thanks for the feedback.

Happy to have helped you.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão