View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default work days function

Try this:

A1: (a date)
B1: (the number of workdays to increment A1 by)
C1: =WORKDAY(A1,B1)

Per Excel Help:
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"tom" wrote:

i wish to have a1=today() b1 = # and c1 return the working days forward.

ie.

july 1 2006
15
july 21 2006