View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default 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...