View Single Post
 
Old 09-11-2011, 02:06 AM
USAOz USAOz is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jan 2011
Location: Sydney Australia
Posts: 9
USAOz is on a distinguished road
Cool Formula to calculate Leap Year

I need a formula that will calculate if a year that falls with in a fiscal (financial) year is a Leap Year or not.

For example if I enter the start date for a fiscal year in a cell (e.g. 1 July 2011) and the end date of the fiscal year in another cell (e.g. 30 June 2012) I'd like a message to be displayed in the formula cell saying "Leap Year" if ANY part of the date range falls in a Leap Year (as it would in this example) or a blank cell (no text) if the entire date range does NOT fall in any Leap Year.

Any ideas on how this calculation could be done?
Reply With Quote