Excel formula - Add days to date based on drop down selection [Solved/Closed]
Sabernethy2
Posts Tuesday August 15, 2017Registration date
August 17, 2017
Last seen
-
Aug 15, 2017 at 05:31 PM - Latest reply: Mazzaropi1834
Posts Monday August 16, 2010Registration dateContributorStatus
May 30, 2018
Last seen
- 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))
