Don't get what you are asking. By my calculation, h10 has nothing to do
with leap years, and comes to 9 days, h13 comes to 357, so any leap years is
not taking it beyond 365.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kckar" wrote in
message ...

I need a formula that counts leap years as 365 days instead of 366 days.



My work sheet is set up as follows:

c10=6/6/2003
f10=06/15/2003
h10=f10-c10

c13=6/15/2003
f13=6/6/2004
h13=f13-c13


i need the sum of h10 and h13 to always equal 365 even if it is a leap
year


other things that may help you understand this worksheet:
c9=prior anniversary date
f9=calculation date
h9=low days
c12=calculation date
f12=next anniversary date
h13=high days

and i need high days and low days to always equal 365

i need excel to never calculate a february 29


--
kckar
------------------------------------------------------------------------
kckar's Profile:
http://www.excelforum.com/member.php...o&userid=25322
View this thread: http://www.excelforum.com/showthread...hreadid=387998