Calc dates and office-day calculations
Build month and week headings, count or shift office days, and separate dates from a whole-second clock view.
Extend Calc month headers across a year boundary
Normalize to the first day and advance typed dates by calendar months.
Calculate a month-end cell for a Calc report
Return the selected month’s final day and the next month’s first day.
Count Calc office days with an editable closure list
Count valid weekday endpoints and subtract only the supplied numeric closures.
Move a Calc review date by stated office days
Return a date after a whole-number office-day offset.
Create a Monday-start week heading in Calc
Use the stated weekday convention to calculate the week’s boundaries.
Separate a Calc date-time into date and clock cells
Split one known numeric date-time while preserving the source value.