sarbanes oxley spreadsheet control measurements are discussed on this website and page

Thank you for visiting our site. Please tell everyone you know about us.

Courtesy of www.AuditExcel.co.za

Below is the requested video clip. Other pages you may want to visit on this site:

AuditExcel.com- More training material

Training - Our training index for all things spreadsheet.

Home Page - See everything we offer

or use the search bar to the right to find exactly what you want.

Email us on info@AuditExcel.co.za if you have any questions

Web	AuditExcel.co.za

Video loading. While you wait, see what other videos are available on the left hand side

Transcripts for the above video clip:

Weekday

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 1^stJan 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.