View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson[_2_] Dave Peterson[_2_] is offline
external usenet poster
 
Posts: 420
Default 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