Adding weekdays in a date formula

[Handy]

How would you add weekdays to a formula? ex.

A1 = 1/1/10

If I want to add 80 WORKDAYS (excluding weekends), what formular would I use?
=(A1+80) does't work...

 

[Luke M]

You were close to the name...

=WORKDAY(A1,80)

Note that you can add a third arguement to this function to define holidays,
if desired.

 

[Mike H]

Hi,

Try this formatted as a date

=WORKDAY(A1,80)

If you get a #NAME error then
Tools|Addins and check the analysis toolpak. the formula can also take a
third argument

=WORKDAY(A1,80,B1:B10)

Where B1:B10 contaions a list of dates (Holidays) you would also like to
exclude.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.