Microsoft Office Tutorials and References

In Depth Information

**WEEKDAY**

could use the
TODAY
function to calculate the total days you have left to complete a project or

pay a bill. Notice the examples in Figure 4.9—the first example shows the
TODAY
function in

cell D6 and the completion date of the project is 7/16/1999 in cell C6. Because the
TODAY

function always displays the current day, it can keep a running tab on how many days are left.

The second example shows bill payments, where today is the current date, the bills have

different due dates, and the days left keep a running log on how many days until the bill

comes due. A conditional format highlights and warns bills coming due in less than 10 days

in addition to bills that are past due.

Figure 4.9

The
TODAY
function

can operate as a

time management

tool as shown in

both examples.

D

Date due

A

Conditional formats

B

Automated time calculations

C

Tr acks current day

WEEKDAY

WEEKDAY
returns the corresponding day of the week as a serial number.

=WEEKDAY(serial_number,return_type)

The
WEEKDAY
function is another function that can be a powerful tool when combined with other

functions. It returns the number corresponding to the day of the week between 1 and 7, where the first day

of the week is Sunday and the seventh day is Saturday. If your date format is 1/1/00 and you’re

planning your work schedule, you can simply type in the cell,
=WEEKDAY(“1/1/00”)
, or reference a cell as

shown in Figure 4.10. Notice the second example uses the IF function. This formula guarantees that

any date in the future will land on a workday. For example, let’s say you’re planning to deliver certain

materials to a vendor on multiple dates in the future, you could use this formula to always guarantee a

weekday result. The actual day appears on Saturday in cell C22, however, the guaranteed formula kicks

it to Friday. If the day landed on Sunday, the formula would kick it to Monday.