WEEKDAY function


Returns a number identifying the day of the week.



=WEEKDAY( serial_number[return_type] )


required arguments:

serial_number The number for which you want to get the day of the week.


optional arguments:

[return_type] A number 1-3 representing a day of week mapping scheme. The default is 1.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.