Hi people - I count myself as a bit of a novice - so sorry if this is really
dumb! I have had a look on line and can see some similar looking enquiries -
except those want to do more complicated things than me. I simply want to put
two dates into two cells on the same row and count the number of working days
(Mon-Fri) including both start and end date.

e.g. at the moment if put in 20/06/07 - 25/06/07 it returns the value of -5
-when I want it to return a value of -6 (+2 for the weekend)= -4

Thanks for your help folks

Darren
Farnborough UK

=NETWORKDAYS(A1,B1)

earlier date in A1 returns 4 or later date in A1 returns -4

"Infinitebiscuit" wrote:

Hi people - I count myself as a bit of a novice - so sorry if this is really
dumb! I have had a look on line and can see some similar looking enquiries -
except those want to do more complicated things than me. I simply want to put
two dates into two cells on the same row and count the number of working days
(Mon-Fri) including both start and end date.

e.g. at the moment if put in 20/06/07 - 25/06/07 it returns the value of -5
-when I want it to return a value of -6 (+2 for the weekend)= -4

Thanks for your help folks

Darren
Farnborough UK

Direct from Excel help... Give it a go!

NETWORKDAYS
See Also

Returns the number of whole working days between start_date and
end_date. Working days exclude weekends and any dates identified in
holidays. Use NETWORKDAYS to calculate employee benefits that accrue
based on the number of days worked during a specific term.

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

How?

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

NETWORKDAYS(start_date,end_date,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.

I tested it using your dates and it gave the result of 4.



On 20 Feb, 11:58, Infinitebiscuit
wrote:
Hi people - I count myself as a bit of a novice - so sorry if this is really
dumb! I have had a look on line and can see some similar looking enquiries -
except those want to do more complicated things than me. I simply want to put
two dates into two cells on the same row and count the number of working days
(Mon-Fri) including both start and end date.

e.g. at the moment if put in 20/06/07 - 25/06/07 it returns the value of -5
-when I want it to return a value of -6 (+2 for the weekend)= -4

Thanks for your help folks

Darren
Farnborough UK