Re: Formula for adding only workdays

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

See help on WORKDAY function.

Note: you must load the Analysis ToolPak to make that function available.


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 12:48:15 -0800, JoAnn <JoAnn@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I need to have a date column that contains a date that is 3 workdays from the
date specified in another column ("date submitted").

Right now it's set to give me 3 days from the date in the submission column
but I need to have it skip weekend dates in its calculation.

Is there a way to do that?

.

Relevant Pages

  • Re: Formula to determine 10 business days
    ... See help on WORKDAY function from the Analysis Toolpak. ... Gord Dibben MS Excel MVP ... business days from today's date? ...
    (microsoft.public.excel.worksheet.functions)
  • Cross platform VBA issue
    ... When Windows users create a worksheet that uses the WORKDAY function from ... the analysis toolpak for VBA, that document frequently returns the #NAME ... Analisys toolpak for VBA enabled. ...
    (microsoft.public.mac.office.excel)
  • Re: Set a date as a constant to work back from to show only weekdays
    ... I would like this to round back to the nearest ... If the WORKDAY function is not available, ... On the Tools menu, click Add-Ins. ... In the Add-Ins available list, select the Analysis ToolPak box, and then click ...
    (microsoft.public.excel.misc)
  • Re: Formula help needed
    ... this uses the WORKDAY function from the Analysis Toolpak (ATP). ... Les ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Subtracting weekdays from a date:
    ... You may not have the Analysis Toolpak addin selected. ... Excel Help on WORKDAY function) ... by using the Add-Ins command on the Tools menu. ... "Richard" wrote: ...
    (microsoft.public.excel.worksheet.functions)