Microsoft Excel Functions & Formulas

Use the WEEKDAY function to calculate with

different hourly pay rates

Many companies calculate payroll using hourly rates for each

employee. The hourly rates depend on which days are worked, as

work performed on the weekend often is paid at a higher rate than

work performed Monday through Friday.

In this example, different hourly rates are defined based on

which days are worked. Column A lists the dates, column B has the

custom format DDD to show the day of the week, and column C

lists the number of hours worked.

4

To calculate with different hourly pay rates:

1. In a worksheet, enter the data shown in columns A, B, and

C in Figure 4-18.

2. Select cell F2 ...