+ Reply to Thread
Results 1 to 3 of 3

How to get the number of days in a year?

  1. 03-10-2005, 12:07 AM #1
    aijihz
    aijihz is offline
    Registered User
    Join Date
    03-09-2005
    Posts
    39

    Talking How to get the number of days in a year?

    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!!!
    Reply With QuoteRegister To Reply
  2. 03-10-2005, 12:20 AM #2
    duane
    duane is offline
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    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.....
    Reply With QuoteRegister To Reply
  3. 03-10-2005, 01:45 AM #3
    mangesh_yadav
    mangesh_yadav is offline
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    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.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1