Mine goes correctly from 28 Feb 2100 to 1 Mar 2100, so it looks like you've
got a separate problem.
--
David Biddulph
"mubashir aziz" wrote in message
...
Try to write 1-feb-2100 and drag it down. Is it giving you 29-Feb-2009
????? That is widnow prolbem like we had before start of 2000 ....
David Biddulph;351289 Wrote:
Doesn't that make 2100 a leap year?
--
David Biddulph
mubashir aziz wrote:
Try this formula as i've used it and NA() is the best approach to be
ignored in chart .... you can hide #NA error with conditional
formatting or cell error as blank ..........
sample formula = IF(Conditon<YEAR IS LEAP,"LEAP","NOT LEAP")
=IF(MOD(YEAR(B2),4)=0,AC2+1,NA())
I'm considering that first date is in B2 and o last cell is AD2
having
above formula ....
Here your current year will be zero if that is leap year and first
formula will work else 2nd option ..... Try this and do let me know
--
mubashir aziz
If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile:
http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98265