Posted to microsoft.public.excel.misc

Mike M.[_2_] Mike M.[_2_] is offline

external usenet poster

Posts: 6

IF formula to allow Feb 29th in a leap year

I know the rule that a leap year has to be divisable by 400 or divisable by 4
& 100 but I can't figure out how to put it in a IF formaula. Can anyone help?

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
How do I change the following formula to allow for leap year	Linda432	Excel Discussion (Misc queries)	3	June 11th 08 02:29 PM
Leap Year	Jet	Excel Discussion (Misc queries)	3	March 20th 08 04:17 PM
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

All times are GMT +1. The time now is 04:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us