View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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...