days Articles: Excel and Google Sheets

All resources related to days for Excel and Google Sheets.


Calculate date 90 days ago in Excel – Excelchat
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...
Calculate date 30 or 60 days before today – Excelchat
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...