Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-18-2016, 07:13 AM
euterpia euterpia is offline adding days to a date Windows 7 64bit adding days to a date Office 2010 64bit
Novice
adding days to a date
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding days to a date 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
adding days to a date How to count even exact date 90 days redza Excel 1 09-17-2013 03:36 AM
adding days to a date 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft