You're welcome

Another approach that would also work

=365+(MONTH(DATE(A2,2,29))=2)

Success click yes
--
Wag more, bark less


"igbert" wrote:

Thanks, formula works preferct for any year.


"Brad" wrote:

assume 2008 is in a2
in b2
=DATE(A2+1,1,0)-DATE(A2,1,0)

Success - click yes.
--
Wag more, bark less


"igbert" wrote:

Is there a fuction to return the days in a given year?

Entry Return

2008 366
2010 365

Igbert