day

Day of month

Syntax

DayMonth = day(Date)
DayMonth = day(Date, F)

Description

DayMonth = day(Date) returns the day of the month given a serial date number or date string.

DayMonth = day(Date, F) returns the day of the of the month, given a serial date number or date string, in a specified date format.

Examples

DayMonth = day(730544)

or

DayMonth = day('2/28/00')
DayMonth =

         28.00

You can also use the F argument to designate a country-specific date format:

DayMonth = day('28/02/00','dd/mm/yyyy')
DayMonth =

         28.00

See Also

| | |

Was this topic helpful?