Formulate column to accept dates with varying add to dates minus weekends.

Sounds like you need the 'WORKDAY' function.
I believe it is a part of the Analysis Toolpak that comes with Excel. If
it's not loaded, go to...
ToolsAdd-ins...
and select 'Analysis ToolPak'
Now the 'WorkDay' function will definitely be available. It will not only
adjust for weekends but also Holidays if you want to specify them!
For example:
If Feb-06-2006 is in A1 and you want to add 3 days to it...
=WORKDAY(A1,3)
will give Feb-09-2006

If Feb-06-2006 is in A1 and you want to add 5 days to it...
=WORKDAY(A1,5)
will give Feb-13-2006

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Sheila" wrote:

Formulate column to accept dates with varying add to dates minus weekends.