There are all sorts of formulas (Zeller's congruence, etc.), but the simplest way in VB/VBScript is a kludgy trick. Simply build the date for the year you want (e.g. 2/29/xxxx when xxxx is the year) and do an ISDATE function on it. Simple, yes? If xxxx is not a leap year, ISDATE will return false.
Sneaky!<BR><BR>And of course, I couldn't take your word for it... I went ahead and tested it ;)<BR><BR>Public Function checkLeapYear(ByVal dYear as Date) As Boolean<BR> checkLeapYear = IsDate("2/29/" & dYear)<BR>End Function<BR><BR><BR>Neat little function, and simple at that.