kckar wrote...
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
....

OK, so what's wrong with

=MIN(365,H10+H13)

?