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.
Search JabSto ::




Custom Search