• Good article, I couldn't agree more! Some things regarding dates and calendars cannot (easily) be caught in formulae, take for example:

    1. Weeknumbering around newyear. Some don't want a week 53 and sure don't want January 1st to be part of week 53 of the last year

    2. Working days: is a specific date a working day or a non-working day?

    3. Rare, but I now some cases: for example invoice dates should always fall on a working day. What if we invoice on a Sunday? Move it to the next working day

    4. Quarter / Period based on a 4-4-5 week schedule

    Things like these I always solve using a calendar table. Seems more logic to the customer as well!

    René

    Kind regards,
    René Berends