Obtain days in a given year
=date(2010,1,1)-date(2009,1,1)
would give the number of days in 2009.
If you put the interested year in A1, you could use:
=date(a1+1,1,1)-date(a1,1,1)
(well, except for 1900.)
On 05/14/2010 11:23, igbert wrote:
Is there a fuction to return the days in a given year?
Entry Return
2008 366
2010 365
Igbert
|