Hey David pls. don't get personnel wd: , I don't ve to take anything
with leap year as i was just concerned about my formula and in any case
it will work fine :) as whatever be the dates .......



David Biddulph;352811 Wrote: [color=blue]
In your country 2100 may be a leap year, but it isn't in the rest of
the
world.
--
David Biddulph

mubashir aziz wrote:
I think you didn't read my answer properly i asked that did you get
29th Feb 2100 as 2100 is a leap year. If not then there is nothing
wrong with formula and it will help to make chart etc. ....


David Biddulph;351405 Wrote:
Mine goes correctly from 28 Feb 2100 to 1 Mar 2100, so it looks
like[color=green]
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())
mubashir aziz

If this post helps Don't 4get to click Yes




--
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