I got tired of always doing the calculations in formulas to find different dates. So I decided to just create one table that did the calculations then just lookup the date needed. It makes formulas in my docs much cleaner to understand and edit.
Date to Base Calculations on:
10/2/2022 5:08:49 PM
Calculate Days
Last Month
Last Week
Yesterday
Current Date
Tomorrow
Next Week
Next Month
Beginning this Week
End this Week
Beginning Next Week
End Next Week
Beginning This Month
End This Month
Beginning Next Month
End Next Month
Last Month
Last Week
Yesterday
Current Date
Tomorrow
Next Week
Next Month
Beginning this Week
End this Week
Beginning Next Week
End Next Week
Beginning This Month
End This Month
Beginning Next Month
End Next Month
9/2/2022
9/25/2022
10/1/2022
10/2/2022
10/3/2022
10/9/2022
11/2/2022
10/2/2022
10/8/2022
10/9/2022
10/15/2022
10/1/2022
10/31/2022
11/1/2022
11/30/2022
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
