DAY

Extracts the day of the month from a date, as in =DAY(E5) giving 15; it is the companion of MONTH and YEAR.

When to use

In the calendar the last day of the month is found with DAY of an EOMONTH result, as in DAY($O$2), which a conditional-formatting rule then uses to hide overflow days.

See Lec 04.

Appears in

No references yet.