New FAQ: Complete Guide To Leap Years

[Unscruffed]

Anyone looking for comprehensive info about calculating Leap Years, please be advised of a new tutorial at faq222-6901.

Cheers,
Scruff.

Be good. If you can't, don't get caught!

 

[johnwm]

Fascinating bit of history - but IsDate provides the same info in one line.

Msgbox IsDate("29/02/" & myYear)

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[JoeAtWork]

That's certainly the most scholarly FAQ I've ever seen on Tek-Tips!

 

[PeterWallace]

Slight Fat Finger problem with the F A Q


the Gregorian Calendar was introduced on

24 February 1582

NOT

24 February 1852 as stated in FAQ


Peter

 

[Unscruffed]

Thanks for the comments guys, much appreciated.

Forgot about IsDate, didn't I? Thanks John, I'll fix that tonight. As it's the easiest method to code, it's certainly worth a mention.

The plan was to show not only how to code the formula, but give an understanding of why the formula is needed in the first place. So, I guess I succeeded in that area. Thanks Joe.

The "fat finger" issue has been been corrected. Thanks Peter.

Be good. If you can't, don't get caught!

 

[strongm]

>the Gregorian Calendar was introduced on
> 24 February 1582

But not everyone signed up to the idea then. The Protestant German countries didn't sign up until 1700. England (and the American colonies) didn't make the (by now 11 day) change until September 2, 1752 - and there were riots demanding the days back

 

[BobRodes]

< riots demanding the days back
I suppose because employers found in this some convenient way to dock employees' pay...

 

[harebrain]

>But not everyone signed up to the idea then.
It took the Communists to get most of Russia up to speed on this: the Orthodox church still isn't on board.

 

[docjohn52]

Sweet, very nice!

Thanks man!