Thread: [Solved] adding days to a date
View Single Post
 
Old 01-18-2016, 07:13 AM
euterpia euterpia is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2016
Posts: 1
euterpia is on a distinguished road
Default adding days to a date

Hello,

I'm trying to work something out in Excel. Wat i would like to have:

If A1 contains the word 'ship' or 'boat', then A3 should give the 21 days from today.
If A1 doesnt contain the word, then A3 should give 10 days from today.

Of couse I need to use the if-function, true or false value , but how do I go about the dates?

Thanks for the help!
Reply With Quote