Day Function

Returns a value that represents the day of the month based on a serial date number generated by DateSerial or DateValue.


Day (Number)

αƒ“αƒαƒ‘αƒ αƒ£αƒœαƒ”αƒ‘αƒ£αƒšαƒ˜ αƒ›αƒœαƒ˜αƒ¨αƒ•αƒœαƒ”αƒšαƒαƒ‘αƒ:



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.

Error codes:

D'oh! You found a bug (text/sbasic/shared/00000003.xhp#err5 not found).


Sub ExampleDay
    Print "Day " & Day(DateSerial(1994, 12, 20)) & " of the month"
End Sub

Please support us!