Page 10 of 16PREVNEXT

# Figure out dates by using formulas

###### Quick reference card

Formula in the worksheet
Formula result
Formula in the formula bar

Suppose you need to find a date, such as an invoice due date or project end date, that occurs a number of workdays (Monday through Friday) before or after a certain date. It's easy: use the WORKDAY function.

Imagine that you have 80 workdays in which to complete a project that begins on 12/31/2004, and you need to find the project end date. First you would enter those values into cells A2 and A3, as shown in the picture. Next, you would enter the dates of any holidays likely to affect the calculation, each holiday in its own cell. Then you would type the formula into an empty cell:

=WORKDAY(A2,A3,A4:A6)

The project must be completed by 4/26/05. Excel added 80 days (cell A3) to 12/31/2004 (cell A2), automatically excluding weekends as well as the holidays in this period listed in the argument A4:A6 (the colon indicates a range of cells). A comma separates each individual argument. The parentheses separate the arguments from the function.

Page 10 of 16PREVNEXT