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 YEAR function extracts the year from a time value and returns it as a four-digit number. If you work with time but only care about the years, this function lets you eliminate everything else. ℹ️ Remember that dates are just saved as numbers by your spreadsheet with date formatting applied. Purpose The YEAR function … Read more
Return the month from a date.
The DAY function is a simple date function that extracts just the day from a given time. If you work with times but only care about the day, this function lets you get rid of everything else. Typically you will find this function combined with others to return a number for further calculation. This function … Read more
The MINUTE function is a simple date function that extracts just the minute from a given time. If you are working with times but only care about the minutes, this function lets you get rid of everything else. Remember that dates are just saved as numbers by your spreadsheet with date formatting applied. Purpose The … Read more