Calculating a Work Day Date

[Roger F Swinderman]

Hi All
I have a speadsheet to arrange a date a tool is dispatched, entered in cell
C3(date format): next column D3 the number of days for repair (Number) and
E3 indicates C3 + D3 in date format, but I need D3 to calculate work days
and not include weekends.

TIA

****************************************************************************
****************************************************************************
**
ROGER F SWINDERMAN
LOGISTICS CONTROLLER

SHOWPLA PLASTICS LTD
Phone: 01922 419203
Fax: 01922 419225
Mobile: 07990 588670
(e-mail address removed)
www.showplaplastics.ci.uk

The information included in this e-mail is of a confidential nature and is
intended only for the addressee. If you are not the intended addressee, any
disclosure, copying or distribution by you is prohibited and may be
unlawful. Disclosure to any party other than the addressee, whether
inadvertent or otherwise is not intended to waive privilege or
confidentiality. Although this e-mail and attachments are believed to be
free from any virus, or other defect which might affect any system into
which they are received or opened, it is the responsibility of the recipient
to ensure that they are virus free and to check that they will not adversely
affect its systems and data. No responsibility is accepted by the company
for any loss or damage arising in any way from their receipt, opening or
use.
****************************************************************************
****************************************************************************
**

 

[Andy B]

Hi

You could use WORKDAYS function:
=WORKDAYS(C3,D3)

 

[Frank Kabel]

Hi
try
=WORKDAY(C3,D3)

Note: the Analysis Toolpak Addin has to be installed for
this

-----Original Message-----
Hi All
I have a speadsheet to arrange a date a tool is dispatched, entered in cell
C3(date format): next column D3 the number of days for repair (Number) and
E3 indicates C3 + D3 in date format, but I need D3 to calculate work days
and not include weekends.

TIA

********************************************************** ******************
******************
**
ROGER F SWINDERMAN
LOGISTICS CONTROLLER

SHOWPLA PLASTICS LTD
Phone: 01922 419203
Fax: 01922 419225
Mobile: 07990 588670
(e-mail address removed)
www.showplaplastics.ci.uk

The information included in this e-mail is of a confidential nature and is
intended only for the addressee. If you are not the intended addressee, any
disclosure, copying or distribution by you is prohibited and may be
unlawful. Disclosure to any party other than the addressee, whether
inadvertent or otherwise is not intended to waive privilege or
confidentiality. Although this e-mail and attachments are believed to be
free from any virus, or other defect which might affect any system into
which they are received or opened, it is the

responsibility of the recipient

 

[Don Guillett]

From Help
WORKDAY
See Also

Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date). Working days
exclude weekends and any dates identified as holidays. Use WORKDAY to
exclude weekends or holidays when you calculate invoice due dates, expected
delivery times, or the number of days of work performed.

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

How?

1.. On the Tools menu, click Add-Ins.
2.. In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
3.. If necessary, follow the instructions in the setup program.
Syntax

WORKDAY(start_date,days,holidays)

Important Dates should be entered by using the DATE function, or as
results of other formulas or functions. For example, use DATE(2008,5,23) for
the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Start_date is a date that represents the start date.

Days is the number of nonweekend and nonholiday days before or after
start_date. A positive value for days yields a future date; a negative value
yields a past date.

Holidays is an optional list of one or more dates to exclude from the
working calendar, such as state and federal holidays and floating holidays.
The list can be either a range of cells that contain the dates or an array
constant of the serial numbers that represent the dates.