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.