Date Library
Provides 5g functions for working with dates and schedules.
https://gist.github.com/CHatmaker/fcbd2ffab850a4affc80ac0553cf732a
CountDOWλ Count instances of a specific week day within two dates. Are you closed Sundays? How many Sundays are there next month?
CountDOWInMonthλ Count instances of a specific week day within a month. Will the plant run Saturdays in July? How many Saturdays is that?
IsBetweenλ Determine if a value is between a lower and upper limit. Why Excel doesn't have this is a mystery.
IsLeapYearλ Determine if a if a date is in a leap year.
IsOccurrenceDateλ Determine if a date passed is when a potentially repeating event happens. I use this for budgeting and projects.
OverLapDaysλ Return how many days overlap two period ranges. Rent by the day but bill by the week? This can help with that.
PeriodLabelλ Creates a label for a date based on period interval. Want reports with easy to read period headings? Use this.
Periodsλ Determine the number of periods from date1 to date 2 inclusive. This is like the deprecated =DateDif() but better.
ScheduleRatesλ Schedules rates in a timeline from a start date until a new rate replaces it. Use this for rental rates, commission rates, etc.
ScheduleValuesλ Schedules values in a timeline from a scheduled date table. Need to place asset acquisition costs in a timeline?
Timelineλ Creates a horizontal list of start or end dates for a timeline. Timelines made easy and flexible.
DeriveTimelinesλ Create internal start and end timelines based on the model's timeline