Written by Calculates the difference between two dates, based on a 360-day year model commonly utilized in financial interest computations.
Calculates the days between two specified dates.
Provides the numeric representation of the day of the month for a specified date.
Transforms a specified date string in a recognizable format into a date value.
Determines the interval in days, months, or years between two specified dates.
Transforms the specified year, month, and day into a date format.
Calculates the variance of an entire population drawn from a database table-like array or range using a SQL-like query.
Calculates the variance of a population sample chosen from a database-like array or range with a SQL-style query.
Calculates the total of values extracted from a database-like range or array using a query similar to SQL.
Calculates the standard deviation for an entire population drawn from a database-like array or range using a SQL-inspired query.