Excel calendar function !!??

[Luke]

Hi all,

I need a little help...

I am trying to write a worksheet function using a calendar of some sort to
work out the number of days between two dates.

It would be a great help if someone could give me any pointers and to make
things a little more tricky I need to exclude weekends if at all possible.

Cheers,

I know there must be a solution out there somewhere!

 

[Luke]

Don't worry a little more digging and I have found the NETWORKDAYS()
function

Cheers anyway....

For those who are interested, the network days function doesn't technically
do what it says it does!

The function returns number of days between two dates which is what I
wanted, but it actually counts the first date too which actually gives you
one more day than you need if you only want the period between the two
dates!

but this is easy to amend by doing the following:

=(NETWORKDAYS(date,date,holiday:holiday)-1)

Where dates are the from and to dates and holiday:holiday is a range of
dates to exclude, i.e weekends and bank holidays

And to remove the excess day I put the bracket around the entire function as
shown with the -1

 

[Bob Phillips]

Luke,

I think it does calculate the NET WORKing DAYS. If you start on Friday and
finish on Monday, that's 2 working days by my calculation.