On 14 Mai, 18:19, Brad wrote:
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

=337+DAY(DATE(A1,3,0))

Regards,
Bernd