Adding weekdays in a date formula

  • Thread starter Thread starter Handy
  • Start date Start date
H

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...
 
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.
 
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.
 
Back
Top