Assume that you are having the Year in A1. Copy and paste the below formula
in B1 cell.
=IF(A1="","",DATEDIF(DATE(A1,1,1),DATE(A1+1,1,1)," D"))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"igbert" wrote:

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

Entry Return

2008 366
2010 365

Igbert