adding days to a date

euterpia · #1 01-18-2016, 07:13 AM

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!

Debaser · #2 01-18-2016, 07:42 AM

You can use:
=TODAY()+IF(OR(A1={"ship","boat"}),21,10)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Format for days 01-12 are americanized	jcrennan	Excel Programming	9	09-08-2015 01:33 PM
Adding text before a date merge field AND fomatting date as well	NikkiR	Mail Merge	1	08-06-2014 07:18 PM
How to count even exact date 90 days	redza	Excel	1	09-17-2013 03:36 AM
Date Field to add 10 Days to Current Date	Erbwon	Word	6	11-12-2012 06:17 PM
Set calendar alarm x days before end date	el_ja	Outlook	2	01-19-2012 10:09 AM