+ Reply to Thread
Results 1 to 4 of 4

adding dates

  1. #1
    Registered User
    Join Date
    02-20-2007
    Location
    germany
    Posts
    2

    Question adding dates

    I hope this makes sense:

    If a date is entered into a cell in one column (A) I need 90 days added to that date in another column (B). If there is no date entered into (A) then (B) needs to be blank. I am also looking for a good source (cheat sheet) that I can ref. with excel formulas and symbols (like what does $ do when in a formula).

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Try this,

    =IF(A1="","",A1+90) then look through the link below oldchippy, there are plenty of links there
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    02-20-2007
    Location
    germany
    Posts
    2

    Thanks

    Thanks for the help.......I waisted a couple hours trying to figure that one out. The links are great as well. This is the best forum site I have visited to date.

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Glad you got sorted, if you read all the links and take it all in, you'll be well away - good luck. Thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1