Types of Date and Time Functions in Google Sheets
The date and time functions in Google Sheets can be grouped into different categories based on their purpose.
year
YEARFRAC Function – Google Sheets
The YEARFRAC function takes two dates and returns the years between them, including fractions of a year. You can optionally specify different methods of counting days. This function can be used to calculate someone’s age. An alternative to YEARFAC is DATEDIF which can return the difference between two days in years, months, or days. Remember … Read more
DATE Function – Google Sheets
Convert a month, day, and year to a date.