IT COMES UP WITH A DATE IN 1975! (WHAT DO THE a1 and a2 at the end mean and
dont i have ti define the network days)

"Chip Pearson" wrote:

Use something like

=A2-A1-NETWORKDAYS(A1,A2)

where A1 is the start date and A2 is the end date. The
NETWORKDAYS is part of the Analysis Tool Pak add-in, so you must
have this loaded to use the function. Go to the Tools menu,
choose Add-Ins, and select Analysis Tool Pak from the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"matt" wrote in message
...
I have to create a billing system as part of some ict
coursework, it needs to
be able to know automatically how many weekend nights there are
between set
dates. ive tried loads of formulas but none work, can anyone
help?