Leap Year
 

A have a simple formula:

K40 * D59 * B310

B310= 28 (Days in February)

I have cells that = year (2008, 2009 etc) that are not used in this formula.

I want a formula that will use 29 days ( as opposed to 28 as stated above)
when
calculating within a leap year. (I have a list of all leap years)

Thanks

Leap Year
 

If your year cell (2008.2009 etc) was - say - B300 then:

=DAY(DATE(B300,3,0))

will return the correct numner of days in February

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jet" wrote in message
...
A have a simple formula:

K40 * D59 * B310

B310= 28 (Days in February)

I have cells that = year (2008, 2009 etc) that are not used in this
formula.

I want a formula that will use 29 days ( as opposed to 28 as stated above)
when
calculating within a leap year. (I have a list of all leap years)

Thanks

Leap Year
 

Thank you

"Sandy Mann" wrote:

If your year cell (2008.2009 etc) was - say - B300 then:

=DAY(DATE(B300,3,0))

will return the correct numner of days in February

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jet" wrote in message
...
A have a simple formula:

K40 * D59 * B310

B310= 28 (Days in February)

I have cells that = year (2008, 2009 etc) that are not used in this
formula.

I want a formula that will use 29 days ( as opposed to 28 as stated above)
when
calculating within a leap year. (I have a list of all leap years)

Thanks

Leap Year
 

You're very welcome.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jet" wrote in message
...
Thank you

"Sandy Mann" wrote:

If your year cell (2008.2009 etc) was - say - B300 then:

=DAY(DATE(B300,3,0))

will return the correct numner of days in February

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jet" wrote in message
...
A have a simple formula:

K40 * D59 * B310

B310= 28 (Days in February)

I have cells that = year (2008, 2009 etc) that are not used in this
formula.

I want a formula that will use 29 days ( as opposed to 28 as stated
above)
when
calculating within a leap year. (I have a list of all leap years)

Thanks