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.
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
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