Chronolize dates with varying days minus weekends

G

Gary L Brown

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...
Tools>Add-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,
 
Top