Excel VBA modules for calendars

Modules to be imported as VBA modules in Excel macro-enabled worksheets, or to save as Excel Complement.

Major features

• Compute Excel date object from a date expressed in Milesian calendar the same way as in Gregorian.
• Display Excel date object as a Milesian date string.
• Extend Excel date capabilities down to year 100.
• Compute Gregorian and Milesian yearly figures, including Gregorian epact and Easter Sunday.
• Compute Date shift and duration between dates.
• Compute Dayofweeks even before 1900.
• Compute mean moon phases near a date.
• Milesian Epact is simplified: formula is Gregorian Epact - 11 (modulo 30).

Works on Windows from Excel 2007 on, on MAC-OS Excel from 2011.

Versions

V1.0: Initial version.
V1.1: Enhance comments.
V1.2: Force a type conversion before a computation in order to avoid a range error.
V1.3: Enhance comments in French. Text file is readeable with Windows' note.exe.
V1.4: Update .bas files from commercial package, give all available modules.
V1.5: Intercalation rule for Milesian calendar is same as Gregorian.

V2.0: Major enhancements

• Total compatibility with Calendar1904 when required.
• Total compatibility with MS date storing method (for dates prior to 1900).
• Hide technical conversion functions.
• Group moon computation in same module as general computations.
  V2.1: Gregorian Epact, Milesian Epact computed from Gregorian Epact.

The attached Excel files helps you computing special dates in 2021 or in other years, ounce the macros are inserted and activated.

Excel VBA module for handling Milesian dates (6m-2019)

Modules to be imported as VBA modules in Excel macro-enabled worksheets, or to save as Excel Complement.

Major features

• Compute Excel date object from a date expressed in Milesian.
• Display Excel date object as a Milesian date string.
• Extend Excel date capabilities down to year 100.
• Compute Milesian yearly figures.
• Compute Date shift and duration between dates.
• Compute Dayofweeks even before 1900.
• Compute Easter Sunday.
• Compute mean moon phases near a date.

Works on Windows from Excel 2007 on, on MAC-OS Excel from 2011.

Versions

V1.0: Initial version.
V1.1: Enhance comments.
V1.2: Force a type conversion before a computation in order to avoid a range error.
V1.3: Enhance comments in French. Text file is readeable with Windows' note.exe.
V1.4: Update .bas files from commercial package, give all available modules.
V1.5: Intercalation rule for Milesian calendar is same as Gregorian.

V2.0: Major enhancements

• Total compatibility with Calendar1904 when required.
• Total compatibility with MS date storing method (for dates prior to 1900).
• Hide technical conversion functions.
• Group moon computation in same module as general computations.

Excel VBA module for handling Milesian dates (1m-2019)

Modules to be imported as VBA modules in Excel macro-enabled worksheets, or to save as Excel Complement.
Compute Excel date object from a date expressed in Milesian.
Display Excel date object as a Milesian date string.
Compute mean moon phase.
Extend Excel date capability down to year 100 (MS Windows only).
Works on Windows from Excel 2007 on, on MAC-OS Excel from 2013.
V1.0: Initial version.
V1.1: Enhance comments.
V1.2: Force a type conversion before a computation in order to avoid a range error.
V1.3: Enhance comments in French. Text file is readeable with Windows' note.exe.
V1.4: Update .bas files from commercial package, give all available modules.
V1.5: Intercalation rule for Milesian calendar is same as Gregorian.

Excel VBA module for handling Milesian dates (6m-2018)

Modules to be imported as VBA modules in Excel macro-enabled worksheets.
Compute Excel date object from a date expressed in Milesian.
Display Excel date object as a Milesian date string.
Compute mean moon phase.
Extend Excel date capability down to year 100 (MS Windows only).
Works on Windows from Excel 2007 on, on MAC-OS Excel from 2013.
V1.0: Initial version.
V1.1: Enhance comments.
V1.2: Force a type conversion before a computation in order to avoid a range error.
V1.3: Enhance comments in French. Text file is readeable with Windows' note.exe.
V1.4: Update .bas files from commercial package, give all available modules.

Excel VBA module for handling Milesian dates (1m-2018)

Modules to be imported as VBA modules in Excel macro-enabled worksheets.
Compute Excel date object from a date expressed in Milesian.
Display Excel date object as a Milesian date string.
Compute mean moon phase.
Extend Excel date capability down to year 100 (MS Windows only).
Works on Windows from Excel 2007 on. To be tested with MAC-OS Excel.
V1.0: Initial version.
V1.1: Enhance comments.
V1.2: Force a type conversion before a computation in order to avoid a range error.
V1.3: Enhance comments in French. Text file is readeable with Windows' note.exe.

Excel VBA module for handling Milesian dates (7m-2017)

Modules to be imported as VBA modules in Excel macro-enabled worksheets.
Compute Excel date object from a date expressed in Milesian.
Display Excel date object as a Milesian date string.
Compute mean moon phase.
Extend Excel date capability down to year 100 (MS Windows only).
Works on Windows from Excel 2007 on. To be tested with MAC-OS Excel.
V1.0 : initial version.
V1.1: enhance comments.
V1.2: force a type conversion before a computation in order to avoid a range error.

Excel VBA module for handling Milesian dates (7m-2017)

Modules to be imported as VBA modules in Excel.
Compute Excel date object from a date expressed in Milesian.
Display Excel date object as a Milesian date string.
Compute mean moon phase.
Extend Excel date capability down to year 100 (MS Windows only).
Works on Windows from Excel 2007 on. To be tested with MAC-OS Excel.
Minor changes in comments with respect to V1.0

Excel VBA modules for handling Milesian dates.

Modules to be imported as VBA modules in Excel.
Compute Excel date object from a date expressed in Milesian.
Display Excel date object as a Milesian date string.
Compute mean moon phase.
Extend Excel date capability down to year 100 (MS Windows only).
Works on Windows and Mac OS platform, from Excel 2007 on.
Elaborated on M2017-06-15 (5 Jun 2017), now transferred to GitHub.