How to Calculate Months of Service Using Google Sheets
Find the number of full calendar months an employee has worked.
months
DATEDIF Function – Google Sheets
The DATEDIF function calculates the difference between two days. You can return the difference in days, months, years, or combinations. Whereas the DAYS function will only return days, this function has multiple output options. The input for this function needs to be either surrounded by quotes or a cell reference. If your days, months, and … Read more
WEEKNUM Function – Google Sheets
The WEEKNUM function accepts a date and returns the week number (1 through 54) of that date. The date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a date. If your days, months, and years are in different cells, … Read more
EDATE Function – Google Sheets
The EDATE function increments a starting date by a specified number of months.