Returns a value that represents the day of the month based on a serial date number generated by DateSerial or DateValue.
Number: A numeric expression that contains a serial date number from which you can determine the day of the month.
This function is basically the opposite of the DateSerial function, returning the day of the month from a serial date number generated by the DateSerial or the DateValue function. For example, the expression
Print Day (DateSerial(1994, 12, 20))
returns the value 20.
Sub ExampleDay Print "Day " & Day(DateSerial(1994, 12, 20)) & " of the month" End Sub