13- 17 May, 2013

# Weekday in excel

How to use a date to determine the weekday in excel.

• 01:07
• Skill Level:
• What's my skill level

## 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.

## Handy Tips & Tricks

Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading

## Creating a Waterfall Chart in Excel the easy way

A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading

I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.

– Melco Conveyor Equipment (Pty) Ltd

## View Entire Video Gallery ››

• 03:14
• Skill Level:
• What's my skill level

• 00:42
• Skill Level:
• What's my skill level

## Waterfall chart using stock charts

• 07:11
• Skill Level:
• What's my skill level

## Absolute and Relative cell references

• 06:34
• Skill Level:
• What's my skill level