Results 1 to 6 of 6

Help with condition format or formula to identify a leap year date in a cell

Threaded View

nje Help with condition format or... 10-26-2012, 04:40 AM
Pete_UK Re: Help with condition... 10-26-2012, 04:49 AM
:) Sixthsense :) Re: Help with condition... 10-26-2012, 04:51 AM
benishiryo Re: Help with condition... 10-26-2012, 04:57 AM
nje Re: Help with condition... 10-26-2012, 05:40 AM
Pete_UK Re: Help with condition... 10-26-2012, 05:43 AM
  1. #1
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    Help with condition format or formula to identify a leap year date in a cell

    I have attached a sample sheet.
    I am doing a number of worksheets that will all take the start date from sheet 1. each sheet covers a 3 month period.

    starting at 31/1/12 the next date is 30/4/12 so it just adds 90 days and then similar for the next 3 month periods.
    The problem is that 2012 is a leap year so there are more days in February, so in 2013 the same calculation takes the next period to 1/5/2013 and then has a knock on effect for the following periods.
    The work book will cover a few years so I could do with a conditional format or a formula if possible to identify a leap year from the initial start date. It will probably be easier to refer to my sample sheet to get a better idea of what I'm after.
    Thanks
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1