Leap Year

[Jet]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Jet]

Thank you

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You're very welcome.

--

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk