days Articles: Excel and Google Sheets

When we are asked “What is 90 days prior to today?” we need not fret.  Excel allows us to calculate the date 90 days before today by using TODAY function and subtraction.   Figure 1.  Final result:  What is 90 days prior to today? How to calculate the date 90...

Calculating the date one day or one week before the date today seems easy enough.  However, when we have to determine the date 30, 60 or 120 days before today, it becomes confusing.  Especially when we have to consider that some months have 31 days, others have 30 days, and...