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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 17, 2017 at 11:11 AM
Related:
- Excel formula - Add days to date based on drop down selection
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- How to add 90 days to a date in excel - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
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
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 17, 2017 at 11:11 AM
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
Thanks for the feedback.
Happy to have helped you.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Aug 17, 2017 at 09:39 AM