Archive

ADDMISSINGITEMS

Adds combinations of items from multiple columns to a table if they do not already exist. The determination of which item combinations to add is based on referencing source columns which contain all the possible values for the columns.

To determine the combinations of items from different columns to evaluate: AutoExist is applied for columns within the same table while CrossJoin is applied across different tables.

The ADDMISSINGITEMS function will return BLANK values for the IsSubtotal columns of blank rows it adds.

YEARFRAC

Calculates the fraction of the year represented by the number of whole days between two dates. Use the YEARFRAC worksheet function to identify the proportion of a whole year’s benefits or obligations to assign to a specific term.

YEAR

Returns the year of a date as a four digit integer in the range 1900-9999.

WEEKNUM

Returns the week number for the given date and year according to the return_type value. The week number indicates where the week falls numerically within a year.

WEEKDAY

Returns a number from 1 to 7 identifying the day of the week of a date. By default the day ranges from 1 (Sunday) to 7 (Saturday).

TODAY

Returns the current date.

TIMEVALUE

Converts a time in text format to a time in datetime format.

TIME

Converts hours, minutes, and seconds given as numbers to a time in datetime format.

SECOND

Returns the seconds of a time value, as a number from 0 to 59.

QUARTER

Returns the quarter as a number from 1 (January – March) to 4 (October – December).