Excel formula - Add days to date based on drop down selection
Solved/Closed
Sabernethy
Mazzaropi
- Posts
- 2
- Registration date
- Tuesday August 15, 2017
- Status
- Member
- Last seen
- August 17, 2017
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Excel formula - Add days to date based on drop down selection
- Excel formula add days to date - Guide
- Excel formula to change text color based on value ✓ - Forum - Excel
- Excel formula add 1 if cell contains text - Guide
- If a cell contains any text then add a value ✓ - Forum - Excel
- Excel formula to add rows based on cell value - Forum - Excel
2 replies
Mazzaropi
Aug 16, 2017 at 09:11 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Aug 17, 2017 at 11:11 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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