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
0
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
0
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
0