Skip to content

Excel VBA module for handling Milesian dates (6m-2019)
Compare
Choose a tag to compare
@Louis-Aime Louis-Aime released this 22 Jun 20:20
· 3 commits to master since this release
V2.0
a442484
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

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.
Assets 2
Loading