Date and Time Functions

Question 1

YEARFRAC(start_date, end_date, basis)

Answer 1

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.

Question 2

DATEVALUE(date_text)

Answer 2

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

Question 3

TIMEVALUE(time_text)

Answer 3

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

Question 4

TIME(hour, minute, second)

Answer 4

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

Question 5

WEEKDAY(date, return_type)

Answer 5

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).

Question 6

CALENDARAUTO([fiscal_year_end_month])

Answer 6

Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is calculated automatically based on data in the model.

Question 7

CALENDAR(start_date, end_date)

Answer 7

Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.

Question 8

NOW()

Answer 8

Returns the current date and time in datetime format.

Question 9

TODAY()

Answer 9

Returns the current date.

Question 10

UTCNOW()

Answer 10

Returns the current UTC date and time.

Question 11

UTCTODAY()

Answer 11

Returns the current UTC date.

Question 12

EOMONTH(start_date, months)

Answer 12

Returns the date in datetime format of the last day of the month, before or after a specified number of months. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

Question 13

EDATE(start_date, months)

Answer 13

Returns the date that is the indicated number of months before or after the start date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

Question 14

DAY(date)

Answer 14

Returns the day of the month, a number from 1 to 31.

Question 15

HOUR(datetime)

Answer 15

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Question 16

MINUTE(datetime)

Answer 16

Returns the minute as a number from 0 to 59, given a date and time value.

Question 17

MONTH(datetime)

Answer 17

Returns the month as a number from 1 (January) to 12 (December).

Question 18

DATEDIFF(Date1, Date2, Interval)

Answer 18

Returns the number of interval boundaries between two dates.

Question 19

NETWORKDAYS(start_date, end_date[, weekend, holidays])

Answer 19

Returns the number of whole workdays between two dates (inclusive). Parameters specify which and how many days are weekend days. Weekend days and days specified as holidays are not considered as workdays.

Question 20

QUARTER(date)

Answer 20

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

Question 21

SECOND(time)

Answer 21

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

Question 22

DATE(year, month, day)

Answer 22

Returns the specified date in datetime format.

Question 23

WEEKNUM(date[, return_type])

Answer 23

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

Question 24

YEAR(date)

Answer 24

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