DAYS Function – Google Sheets
The DAYS function calculates the number of days between two dates.
Date
EDATE Function – Google Sheets
The EDATE function increments a starting date by a specified number of months.
EOMONTH Function – Google Sheets
EOMONTH is a function in Google Sheets that returns the ending day of a specified month. If you have many dates in your spreadsheet, this formula lets you quickly find the last day of the month in an automated fashion. Once you have the last day of the month, see here if you want to … Read more
HOUR Function – Google Sheets
The HOUR function extracts the hour value from a time as a number from 1 to 12. If you work with times but only care about the hours, this function lets you get rid of everything else. Remember that dates are just numbers with date formatting applied. This function is often used inside formulas with … Read more
DATE Function – Google Sheets
Convert a month, day, and year to a date.