increment date by a whole year

[Chris Davison]

Evening All,

on behalf of Jack in the UK :

what's the formula for incrementing a cell with a date in it by a whole year (taking into account leap years)

so : 31/07/2002 plus a year would always be 31/07/2003

scource cell is formatted as a date dd/mm/yyyy - I can't just add 365 as this will trip up on leap years

thanks
Jack in the UK

 

[Legacy 1363]

On 2002-04-25 20:23, NateO wrote:
I don't agree with the following:

If the start date is (for example) 28 Feb 2003, both formulas will produce 28 Feb 2004

Obviously no big deal. Did you try it though?

I still think Edate is better, no doubt about it, I'm playing with physics at this point and am pleased that it works...

In any case, have good one!
_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
This message was edited by NateO on 2002-04-25 20:31

The two formulas I was referring to did not include yours, they were the other two :
=EDATE(A1,12)
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

cojones

 

[NateO]

Nice, I was just going through the post you linked to, the debate was on! One way or another the OP got their $'s worth on this one (and the linked one)! I like the multiple option aproach C.O., Keep launching ideas!

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
This message was edited by NateO on 2002-04-25 20:45

 

[Jack in the UK]

cheers guys i know when i spoke with my mate Chris D for 40 mins i was opening a can of worms thats the idea, i eally wanted all sorts of ideas and views that wahat i have got, and thank you all the time and effort, now down to me to sort mytask.

good fun guys well done.

 

[Mark O'Brien]

On 2002-04-25 18:40, NateO wrote:
Actually, I don't agree C.O.

, and that's where I thought the 365.25 broke down. If you set up a datetime of 2/28/1998 12:00:00 pm and start adding 365.25 to it, you'll find 2000 gives you the 29th (same w/ 2004) (at least on my PC). I can't be sure if this is what the Chris/Jack tandem were after, but, since you're interested, try it for the halibut.

Incidentally, why would Mr. Hawley want the 28th?

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
This message was edited by NateO on 2002-04-25 20:00

Hey Nate, no you can't be using this

, I claimed that as my favourite smiley.

Good discussion guys. I'm sorely tempted to make something up about dates just to mix things up.

 

[NateO]

Hey Nate, no you can't be using this

, I claimed that as my favourite smiley.

Hey who knew, sorry about that Mark, is the following taboo as well?

No need for

, I'll move along with respect to smilies.

Have a great weekend all.
_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>

This message was edited by NateO on 2002-04-26 13:08

 

[Jack in the UK]

Well that ant gonna work? Erm!@

_________________
If you can help a guy in trouble -
If you can sort that nagging problem -
Pease try, at home, at work or on a message board.

Others help you!
So PLEASE help if you can - If only the once.

Thank you -

Rdgs
======
This message was edited by Jack in the UK on 2002-04-26 14:48
This message was edited by Jack in the UK on 2002-04-26 14:48