Adding weekdays in a date formula
 

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

Adding weekdays in a date formula
 

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.

--
Best Regards,

Luke M
"Handy" wrote in message
...
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...

Adding weekdays in a date formula
 

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.


"Handy" wrote:

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