Function to count days of year

Dear all,

I would like to count number of days of a certain year for example year 2004 has 366 days, year 2005 has 365 days.

Could anyone help me to use function in Excel to do that.

Thanks,

Nam

Subtracting the two dates and adding one would do that.
e.g.
A1 has the value "1/1/04"
A2 has the value "31/12/04"
A3 has the formula "=A2-A1+1"
The result in A3 is "366" days.
Voila!

Or, if you have a date (e.g. A1 has the value "4/3/04") and you want to find out the number of days in that particular year, this will work too:

=DATE(YEAR(A1),12,31)-DATE(YEAR(A1),1,1)+1
= 366 days