DAYS360 Function – Google Sheets

The DAYS360 function calculates days using 30 days for each month. When using a 365-day daily interest rate computation, the interest rate is divided by 365 and multiplied by the principal for each day you calculate interest. When using a 360-day year method, the interest rate is divided by 360 and multiplied by the principal … Read more

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. To … Read more

WORKDAY.INTL Function – Google Sheets

The WORKDAY.INTL function calculates a workday a given number of workdays away from a date. You can optionally specify a list of holidays to exclude from the count and other weekends. If your days, months, and years are in separate cells, use the DATE function to combine them. This function is different from the WORKDAY … Read more