Tips, tutorials, and add-ons
The WORKDAY function calculates a workday that is a given number of days away from a date. You can optionally specify a list of holidays to exclude from the count. ? If your days, months, and years are in different cells, use the DATE function to combine them. Syntax =WORKDAY(start_date,days,[holidays]) Video Tutorial Related Functions WEEKDAY … Read more
The EDATE function increments a starting date by a specified number of months.
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
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
Convert a month, day, and year to a date.