10 lessons in order
To perform various calculations and manipulations on dates and times, Google Sheets provides a wide range of date functions and formulas. You can add or subtract days to count days between two dates, or extract specific details like the weekday name, month name, or week number from a given date. You can also find the […]
Learn how to calculate age from date of birth in Google Sheets using DATEDIF, YEARFRAC, and methods for years, months, and days.
Add days to a date in Google Sheets using formulas, the WORKDAY and EDATE functions, or Google Apps Script for automatic updates.
Count days from a specific date to today in Google Sheets using TODAY, DATEDIF, ARRAYFORMULA, and automate with Apps Script.
Learn how to compare dates in Google Sheets using logical operators, IF function, TODAY for deadlines, and conditional formatting for visuals.
Learn how to add dates automatically in Google Sheets using fill handle, SEQUENCE, dynamic functions, and skipping weekends.
Learn how to get weekday names from dates in Google Sheets using TEXT, WEEKDAY, CHOOSE, SWITCH, ARRAYFORMULA, and Apps Script methods.
Learn how to add months to a date in Google Sheets using EDATE, dynamic columns, and how to fix date formatting issues easily.
Learn how to calculate months between two dates in Google Sheets using DATEDIF, fractional month formulas, ARRAYFORMULA, and day differences.
Learn how to add years to date in Google Sheets using the DATE function or apply the EDATE function to add years by months easily.