Hi,
May i know how to get the number of days in a year?So that i can differtiate between a leap year and a normal year.Thanks!!!
Hi,
May i know how to get the number of days in a year?So that i can differtiate between a leap year and a normal year.Thanks!!!
if cell a1 has the year this give the number of days in that year:
=if(mod(a1,4)=0,366,365)
not a professional, just trying to assist.....
To be more precise:
=IF(OR(AND(MOD(A1,4)=0,MOD(A1,100)<>0),AND(MOD(A1,4)=0,MOD(A1,400)=0)),366,365)
- Mangesh
Last edited by mangesh_yadav; 03-10-2005 at 01:49 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks