Skip to content

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

Compare
Choose a tag to compare
@Louis-Aime Louis-Aime released this 11 Jan 14:02
· 23 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.
V1.3: Enhance comments in French. Text file is readeable with Windows' note.exe.