The FLOOR.MATH Function
It returns a number rounded down, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the FLOOR function.
It returns a number rounded down, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the FLOOR function.
It returns a number rounded down, toward zero, to the nearest multiple of significance .
It returns a number rounded up, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the CEILING function.
It returns a number rounded up, away from zero, to the nearest multiple of significance .
It returns a formula as a string.
It returns a formula as a string.
It returns the last day of the month that is a given number of months before or after the specified date.
It returns the date that is a given number of months before or after the specified date.
It returns the date that is the given number of days before or after the starting date. Weekends and holidays are excluded. The difference with the WORKDAY function is that it allows custom weekend days.
It returns the date that is the given number of days before or after the starting date. Weekends and holidays are excluded.