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

[chrono1081]

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

 

[TwinCities Dan]

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?

 

[-aggie-]

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?

That is correct. Just make the cell formats be by date.

 

[chrono1081]

Thanks guys I was making it waaaay more difficult then it needed to be

 

[mysterytramp]

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