Tips, tutorials, and add-ons
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
The DAYS function calculates the number of days between two dates.
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
The EDATE function increments a starting date by a specified number of months.