Dynamic today and yesterday date in Excel and Google Sheets

=TODAY() // Today date

=TODAY()-1 // yesterday date

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Dynamic today and yesterday date in Excel

How to get dynamic today or yesterday date in Excel?
Dynamic today and yesterday date in Excel

DYNAMIC TODAY OR YESTERDAY DATE — EXCEL FORMULA AND EXAMPLE

  1. =TODAY() // Today date

  2. =TODAY()-1 // yesterday date

Dynamic today and yesterday date in Google Sheets

How to get dynamic today or yesterday date in Google Sheets?
Dynamic today and yesterday date in Google Sheets

DYNAMIC TODAY OR YESTERDAY DATE — GOOGLE SHEETS FORMULA AND EXAMPLE

  • =TODAY() // Today date

  • =TODAY()-1 // yesterday date

Other widely used Excel and Google Sheets formulas explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions