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


    Jan 26, 2008
    Isla Nublar
    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

    May 19, 2008
    Double Parked out front of the Courthouse
    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


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


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


    Jul 17, 2008
    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.


Share This Page