Thread
:
Obtain days in a given year
View Single Post
#
2
Posted to microsoft.public.excel.misc
Brad
external usenet poster
Posts: 846
Obtain days in a given year
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
Reply With Quote
Brad
View Public Profile
Find all posts by Brad