# Alphabetical - D

DATE | The date as a date serial number given a year, month, day. |

DATEDIF | (Compatibility) The number of days, months or years between two dates. |

DATEVALUE | The date serial number given a date in text format. |

DAVERAGE | The arithmetic mean of all the numbers in a column that satisfies multiple conditions. |

DAY | The day as an integer given a date serial number. |

DAYS | (2013) The number of days between two dates. |

DAYS360 | The number of days between two dates, based on 30 day months. |

DB | The depreciation of an asset in a single period (declining balance method). |

DBCS | (2013) The text string converted from single byte to double byte characters. |

DCOUNT | The number of numerical values in a column that satisfies multiple conditions. |

DCOUNTA | The number of numerical values in a column that satisfies multiple conditions (including logical values and text). |

DDB | The depreciation of an asset in a single period (double or triple declining balance method). |

DEC2BIN | The number converted from decimal to binary. |

DEC2HEX | The number converted from decimal to hexadecimal. |

DEC2OCT | The number converted from decimal to octal. |

DECIMAL | (2013) The decimal number of a text representation of a number in a given base. |

DEGREES | The number of degrees given a number of radians. |

DELTA | The numerical value indicating if two numbers are equal. |

DEVSQ | The sum of the squared deviations from the mean. |

DGET | The single value in a column that satisfies multiple conditions. |

DISC | The interest rate (or discount rate) for a security held to maturity. |

DMAX | The largest value in a column that satisfies multiple conditions. |

DMIN | The smallest value in a column that satisfies multiple conditions. |

DOLLAR | The text string of a number with the dollar formatting $0,000.00. |

DOLLARDE | The dollar fraction expressed as a decimal. |

DOLLARFR | The dollar decimal expressed as a fraction. |

DPRODUCT | The product of the values in a column that satisfies multiple conditions. |

DROP | (Microsoft 365) The array without certain rows or columns. |

DSTDEV | The standard deviation of the values in a column that satisfies multiple conditions based on a sample. |

DSTDEVP | The standard deviation of the values in a column that satisfies multiple conditions based on an entire population. |

DSUM | The total of the values in a column that satisfies multiple conditions. |

DURATION | The annual duration of a security that pays interest periodically. |

DVAR | The variance of the values in a column that satisfies multiple conditions based on a sample. |

DVARP | The variance of the values in a column that satisfies multiple conditions based on an entire population. |

DATEThe date as a date serial number given a year, month, day. |

DATEDIF(Compatibility) The number of days, months or years between two dates. |

DATEVALUEThe date serial number given a date in text format. |

DAVERAGEThe arithmetic mean of all the numbers in a column that satisfies multiple conditions. |

DAYThe day as an integer given a date serial number. |

DAYS(2013) The number of days between two dates. |

DAYS360The number of days between two dates, based on 30 day months. |

DBThe depreciation of an asset in a single period (declining balance method). |

DBCS(2013) The text string converted from single byte to double byte characters. |

DCOUNTThe number of numerical values in a column that satisfies multiple conditions. |

DCOUNTAThe number of numerical values in a column that satisfies multiple conditions (including logical values and text). |

DDBThe depreciation of an asset in a single period (double or triple declining balance method). |

DEC2BINThe number converted from decimal to binary. |

DEC2HEXThe number converted from decimal to hexadecimal. |

DEC2OCTThe number converted from decimal to octal. |

DECIMAL(2013) The decimal number of a text representation of a number in a given base. |

DEGREESThe number of degrees given a number of radians. |

DELTAThe numerical value indicating if two numbers are equal. |

DEVSQThe sum of the squared deviations from the mean. |

DGETThe single value in a column that satisfies multiple conditions. |

DISCThe interest rate (or discount rate) for a security held to maturity. |

DMAXThe largest value in a column that satisfies multiple conditions. |

DMINThe smallest value in a column that satisfies multiple conditions. |

DOLLARThe text string of a number with the dollar formatting $0,000.00. |

DOLLARDEThe dollar fraction expressed as a decimal. |

DOLLARFRThe dollar decimal expressed as a fraction. |

DPRODUCTThe product of the values in a column that satisfies multiple conditions. |

DROP(Microsoft 365) The array without certain rows or columns. |

DSTDEVThe standard deviation of the values in a column that satisfies multiple conditions based on a sample. |

DSTDEVPThe standard deviation of the values in a column that satisfies multiple conditions based on an entire population. |

DSUMThe total of the values in a column that satisfies multiple conditions. |

DURATIONThe annual duration of a security that pays interest periodically. |

DVARThe variance of the values in a column that satisfies multiple conditions based on a sample. |

DVARPThe variance of the values in a column that satisfies multiple conditions based on an entire population. |

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top