Menu
Ask a question Report

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

Posts
2
Registration date
Tuesday August 15, 2017
Last seen
August 17, 2017
 - - Latest reply: Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 - Aug 17, 2017 at 11:11 AM
Excel Ask a question Report
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 :)
See more 

2 replies

Report Respond to Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 1117
0
Thank you
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
Report
Sabernethy
Posts
2
Registration date
Tuesday August 15, 2017
Last seen
August 17, 2017
 -
That did the trick!!! Thank you so much for the solution here
Report Respond to Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 1117
0
Thank you
Sabernethy, Good afternoon.

Thanks for the feedback.

Happy to have helped you.

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