Returns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date Returns an integer representing the week number (from 1 to 53) of the year from a user-supplied date Returns the number of whole network days (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days
#Spreadsheet if then formula iso#
Returns the ISO week number of the year for a given date Returns a date that is the last day of the month which is a specified number of months before or after an initial supplied start date Returns a date that is the specified number of months before or after an initial supplied start date Returns the year from a user-supplied dateĬalculates the number of days between 2 dates Returns an integer representing the day of the week for a supplied date Returns a time, from a user-supplied hour, minute and secondĬonverts a text string showing a time, to a decimal that represents the time in Excel Returns the month from a user-supplied date Returns the seconds part of a user-supplied time Returns the minute part of a user-supplied time Returns the hour part of a user-supplied time Returns the day (of the month) from a user-supplied dateĬalculates the number of days between 2 dates, based on a 360-day year (12 x 30 months)
#Spreadsheet if then formula code#
Returns a date, from a user-supplied year, month and dayĬonverts a text string showing a date, to an integer that represents the date in Excel's date-time code Returns the minimum value from a field of a list or database, that satisfy specified conditionsĬalculates the standard deviation (based on an entire population) of values in a field of a list or database, that satisfy specified conditionsĬalculates the standard deviation (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditionsĬalculates the variance (based on an entire population) of values in a field of a list or database, that satisfy specified conditionsĬalculates the variance (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions Returns the maximum value from a field of a list or database, that satisfy specified conditions Returns a single value from a field of a list or database, that satisfy specified conditions Returns the number of non-blank cells in a field of a list or database, that satisfy specified conditionsĬalculates the average of values in a field of a list or database, that satisfy specified conditions Returns the number of cells containing numbers in a field of a list or database that satisfy specified conditions DeleteNamedRange ( name ) Supported functionsįollowing is a list of functions that are supported by SfSpreadsheet Database Functions EditNamedRange ( "Test", "A3:B3", name ) //To remove the named ranges, IName name = spreadsheet. To Edit the named ranges, IName name = spreadsheet.
0 kommentar(er)
