#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
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 |