- Excel 2007
- Excel 2013
- Excel 2016
- Office for Mac 2016
- Office System 2010
- Office System 2013
- Office System 2016
- Visual Studio 2010
Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified for the operating system. Formats without an asterisk are not affected by operating system settings.
database,field,criteria!Returns the largest number in the field (column) of records in the database that match the conditions ...
database,field,criteria!Returns the smallest number in the field (column) of records in the database that match the conditions ...
data_array,bins_array!Calculates how often values occur within a range of values and then returns a vertical array of numbers ...
data_field,pivot_table,field,item,.!Extracts data stored in a PivotTable.!is the name of the data field to extract data from!is ...
Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to ...
date_text!Converts a date in the form of text to a number that represents the date in Microsoft Office Excel date-time code!is ...
decimal_dollar,fraction!Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction!is ...
DeepPink\0Magenta\0Fuchsia\0Violet\0BlueViolet\0Plum\0Orchid\0Thistle\0MediumOrchid\0DarkViolet\0DarkOrchid\0MediumViole ...
Defined names or formulas in this workbook may display different values when they are recalculated in an earlier version ...