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
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 17 Aug 2017 à 11:11
Related:
- Excel formula - Add days to date based on drop down selection
- Excel add days to date - Guide
- Formula to calculate vat in excel - Guide
- Grade formula in excel marksheet - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
16 Aug 2017 à 09:11
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
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
17 Aug 2017 à 11:11
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
Thanks for the feedback.
Happy to have helped you.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
17 Aug 2017 à 09:39