Using Date and Time Function Excel

Choose the function that shows the current date and time from your local computer

• NOW

• TODAY

• DATE

• TIME

TODAY function does not take any arguments.

• True

• False

What date Excel’s serial number begins on?

• January 1, 1900

• December 31, 1899

• January 1, 0000

• Excel's serial numbers cover any date

This function is useful for extracting only the month value for a date.

• mmmm

• MONTH

• SHOWM

• DATE

Which function calculates the number of days between two dates as a whole number.

• DAYS

• =end date - start date

• SUM

• DAY

What function would we use to calculates the end date of the project that lasts 25 business days?

• =WORKDAY(start date, # of days, holiday date range)

• =WEEKDAY(date value, return type)

• =DATEVALUE(date in text form)

• =DAYS(end date, start date)

Which function will show the day of the week for the date stored in cell A2, assuming that Monday is the first day of the week?

• =WEEKDAY(A2,2)

• =DAY(A2)

• =DAY(A2,1)

• =WEEKDAY(A2,0)