Date calculations can be tricky until we develop the intuition for how date data can be manipulated. Being able to manipulate data across time is essential for analysis & reporting. There are different ways to achieve the same things, but below is what I’ve found useful & most intuitive.