Converts a date text string and returns a date/time value. This function is provided for compatibility with other spreadsheet programs.
Returns the date that is the given number of working days before or after a given date. Working days exclude weekends and any other dates specifically excluded.
Evaluates a given value and returns either the number of days represented, if a duration value; or the given value. This function is included for compatibility with other spreadsheet applications.
Calculates the accrued interest added to the purchase price of a security and paid to the seller when the security pays periodic interest.
Calculates the total accrued interest added to the purchase price of a security and paid to the seller when the security pays interest only at maturity.
Returns the total interest included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate.