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!
|