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