DayOfWorkWeek

From CometWiki

Jump to: navigation, search

DayOfWorkWeek Function -- Part of the CometDate series of functions.

Syntax: DayOfWorkWeek(CometDate)

Discussion: The CometDate DayOfWorkWeek function extracts the Day of the Work Week from 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.

CometDate Work Weeks begin on Monday... The DayOfWeek function for any Monday will yield 1, Saturday = 6 and Sunday = 7.

The CometDate functions respect 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 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. There is no year 0 AD, The date goes from 1BC to 1AD.

For a reference of all of the functions associated with CometDates see this page CometDates.

Personal tools