Microsoft Excel Functions & Formulas

Use the WEEKNUM and MOD functions to shade

every other Tuesday

The table shown in Figure 10-5 is part of a schedule for the pur-

chasing department. Purchases are made every other Tuesday.

Create a schedule and color every other Tuesday as a reminder.

Use the WEEKNUM function (introduced in Chapter 4) from the

Analysis ToolPak add-in. This function returns a number that

indicates where the week falls numerically within a year. In combi-

nation with the MOD function, it can be determined if the week

number is even or odd.

4

To mark every second Tuesday:

1. Select cells A2:C20.

2. On the Format menu, click Conditional Formatting.

3. Select Formula Is and type ...