Calculates the average of a range of cells
Counts the number of cells that contain numbers
Returns one value if a condition is true and another if it's false
Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify
Returns the number of whole workdays between two dates using custom weekend parameters
Returns a date before or after a specified number of workdays using custom weekend parameters
Returns the ISO week number of the year for a given date
Returns the number of days between two dates
Returns the number of days between two dates based on a 360-day year
Converts a text time to a decimal number
Returns the hour component of a time value
Returns the minute component of a time value
Returns the second component of a time value
Returns the interest payment for a given period of an investment
Returns the principal payment for a given period of an investment
Returns the cumulative interest paid between two periods
Returns the cumulative principal paid between two periods
Returns the depreciation of an asset using the declining balance method
Returns the depreciation of an asset using the double-declining balance method