Posted to microsoft.public.excel.misc

Jet

external usenet poster

Posts: 4

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
leap year	p-nut	Excel Discussion (Misc queries)	5	January 10th 08 05:34 AM
Leap Year	Ralph Page	Charts and Charting in Excel	3	November 5th 07 01:57 AM
How to determine if year is a leap year	Wanda	Excel Worksheet Functions	7	September 17th 07 07:48 AM
Leap year date	P M Robbins	Excel Discussion (Misc queries)	5	March 30th 06 10:33 PM
leap year question	tiw	Excel Discussion (Misc queries)	5	April 20th 05 07:49 PM

All times are GMT +1. The time now is 01:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us