Dates

Question 1

Fill handle

Answer 1

fill days, weeks, months, and years by highlighting at least two cells that display a pattern

Question 2

TODAY function

Answer 2

The TODAY function returns the serial number of the current date
TODAY()

Question 3

DATEDIF function

Answer 3

Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.

DATEDIF(start_date,end_date,unit)

Question 4

custom dates

Answer 4

formats - more number formats - custom

mmm = first three letters of a month
mmmm = whole name of the month

ddd = first three letters of the weekday
dddd = whole name of the weekday

you can build your own date formats in the custom text bar

Question 5

dd

Answer 5

will give you the numeric value of a day of the month

i.e., dd = any number of a day of the month, like “05, or 16”

Question 6

dddd

Answer 6

will return the written weekday name (Monday - Sunday)

Question 7

mm

Answer 7

returns the numeric value of a month

i.e., mm = 01 for January

Question 8

mmm

Answer 8

returns an abbreviated written representation for the month

i.e., mmm = Jan

Question 9

mmmm

Answer 9

returns the full written name for a month

i.e., mmmm = January

Question 10

eomonth function

Answer 10

Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

EOMONTH(start_date, months)