Skip to content

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

Compare
Choose a tag to compare
@Louis-Aime Louis-Aime released this 11 Jul 13:02
· 27 commits to master since this release

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.