Excel formula - Add days to date based on drop down selection

Solved/Closed
Sabernethy Posts 2 Registration date Tuesday August 15, 2017 Status Member Last seen August 17, 2017 - Aug 15, 2017 at 05:31 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 17, 2017 at 11:11 AM
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 :)
Related:

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 16, 2017 at 09:11 AM
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
Sabernethy Posts 2 Registration date Tuesday August 15, 2017 Status Member Last seen August 17, 2017
Aug 17, 2017 at 09:39 AM
That did the trick!!! Thank you so much for the solution here
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 17, 2017 at 11:11 AM
Sabernethy, Good afternoon.

Thanks for the feedback.

Happy to have helped you.

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