Tips, tutorials, and add-ons
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
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
Count the number of cells with dates that fall between two specified days.
Learn how to use the DATEDIF function to find the number of years, months, or days between two dates.
The DAYS function calculates the number of days between two dates.