Closed Thread
Results 1 to 2 of 2

How to check if a year in a cell is a leap year

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    How to check if a year in a cell is a leap year

    Hey! I am new and would really appreciate help with this. I need a formula that can calculate the following:

    If (cell B1 (2014)) is leap year AND (cell D145=28) (cell F145=D145+1) value if false (cell F145="")

    I was basically trying to make the days auto populate once the days for the first week of the month were inputted. What I would prefer, is to have all the days auto populate based on the current year in cell B1. I attached two worksheet months as reference. If anyone knows a better way, I'm all for it. Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to check if a year in a cell is a leap year

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to check if a year in a cell is a leap year
    By Azuko in forum Excel General
    Replies: 2
    Last Post: 01-31-2014, 07:08 AM
  2. Cell formula for last day of February for leap year or not
    By mikeburg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-27-2014, 02:45 AM
  3. Replies: 5
    Last Post: 10-26-2012, 05:43 AM
  4. Leap year
    By ianma in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-03-2008, 03:26 AM
  5. Leap Year
    By realsaggi in forum Excel General
    Replies: 6
    Last Post: 08-27-2007, 01:29 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1