How to use a date to determine the weekday in excel.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Weekday in excel
The weekday function in Excel allows you to determine what day of the week a particular date was.
So activate the function wizard and go to Date and Time and find the WEEKDAY function. Click OK. You need to tell Excel what to look at so in Serial_number – insert A9 (you want to know what day of the week 1 Jan 2009 was). An important issue here is the Return _type- if you put a 1 it will make Sunday day 1 and Saturday day 7. If you put 2 then Monday is day 1 and Sunday is day 7. I am going to use 2 and you’ll see that 1st Jan 2009 was day 4 which was a Thursday. Click OK and see the result in Column B and C. You can now copy it down your column and you will see for each date what day of the week it was.