Alternate viewpoints and approaches always welcome here.
Yours is a perfectly acceptable approach, and one I used to use myself. However, @Melissa’s date table includes a number of features, which I think make it a much preferred alternative, including the ability to incorporate a holiday table, the ISAFTERTODAY function and most importantly, the use of offsets which are incredibly powerful and can dramatically simplify many time intelligence calculations.
For a full series on maximizing the features of this extended date table, check out this video series:
- Brian