I want to count days between two dates including start date

I

Infinitebiscuit

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
 
C

Ciara

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top