WEEKDAY function for today’s date,
1. Go to “Formula” tab> Select “Date & Time” drop down list and select "Weekday"
2. In the “Serial_number” text box> enter "now()" and click OK
3. The weekday of Monday is now entered in excel which is the number 2 for Monday. This is as the first day of the week is Sunday.
