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

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

Thanks for the feedback.

Happy to have helped you.

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