How to do this in Excel or Numbers? (Adding 60 days to a date)

Discussion in 'Mac Apps and Mac App Store' started by chrono1081, Feb 26, 2010.

  1. chrono1081 macrumors 604

    chrono1081

    Joined:
    Jan 26, 2008
    Location:
    Isla Nublar
    #1
    Hi guys.

    I know this isn't the typical forum question but I can't find an answer online anywhere.

    I have a form that looks like this:

    Name Date of Move Date of Eligibility


    I want the date of eligibility to be 60 calendar days from the date of move, but I can't figure out how to get it to do it :( I have it in Excel right now but can put it in Numbers if need be.

    I'm sure its something easy but I can't figure it out :(
     
  2. TwinCities Dan macrumors 603

    TwinCities Dan

    Joined:
    May 19, 2008
    Location:
    Double Parked out front of the Courthouse
    #2
    Just make "the cell" equal "the other cell"+60... (as long as the formats are similar it should work in both Excel and Numbers)

    right? :confused:
     
  3. -aggie- macrumors P6

    -aggie-

    Joined:
    Jun 19, 2009
    Location:
    Where bunnies are welcome.
    #3
    That is correct. Just make the cell formats be by date.
     
  4. chrono1081 thread starter macrumors 604

    chrono1081

    Joined:
    Jan 26, 2008
    Location:
    Isla Nublar
    #4
    Thanks guys :) I was making it waaaay more difficult then it needed to be :)
     
  5. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #5
    One caveat ... Numbers can be a bit picky when it comes to a date entry. Lots of times you might enter a date like this:

    jan 12, 2010

    And lots of software sees this as a date. Numbers apparently doesn't. You can edit it to be a proper date:

    Jan. 12, 2010

    But Numbers still sees it as a string, and therefore "+60" -- or any operation -- will fail.

    The best solution is to input your dates numerically: 1/12/2010. That seems to always be recognized as a date.

    mt
     

Share This Page