CometDate

From CometWiki

CometDatefunction

Syntax: CometDate(Month, Day, Year)

Discussion: The CometDate function converts three numeric arguments into a CometDate Date Serial Number. CometDates are based on a date of January 1, 1800. CometDates before that date are negative and after are positive.

The CometDate function respects the rules for leap years (i.e., the years 1800 and 1900 were not leap years, but the year 2000 is a leap year).

The numeric arguments, Month, Day and Year are not checked for validity. Physical errors will not result from insane day-month combinations like the 87th day of the 45th month, but the results will obviously not make much sense.

There is no year 0 AD, The date goes from 1BC to 1AD. The practical range of CometDates is -657071 (01/01/01) to 2994623 (12/31/9999) but dates outside of that range may be usable in some contexts.