I'm using the NETWORKDAYS function, in Excel 2007, for a run rate report on sales for several product groups.

=NETWORKDAYS(E3,F3) gives me 22 weekdays for this month, where E3 and F3 cells show the first and last dates of the month.

and

=NETWORKDAYS(B5,F3) gives me the remaining weekdays, where B5 is yesterdays date.

All I need to enter is the current sales so far and the table automagically works out the average daily run rate based on remaining budgetted sales and sales days left in the month.

So far, so good.

The problem is the mailing list includes peeps using Excel 2003 and it doesn't like the NETWORKDAYS function (I think it can, but needs a developer kit installed and our IT dept won't trust us mere mortals with that). Of course I can just use the camera function to mail them all a snapshot, but I would like to use an equivalent function that 2003 recognises.

Can anyone shed some light on this?

Cheers

Spreadie

[edit] Forget it. It isn't a developer kit, I just had to get the 2003 peeps to enable the Analysis tool kit add-in.

Unfortunately no.

Without the NETWORKDAYS add-on pack thingy you'd have to do it long style.

Although I'm not even sure how that would be possible within the spreadsheet itself.

It may have to be done as a VBA thingumy.

In fact, you could do this...

Find the total number of days between the dates (i.e. 25).
Find the number of full weeks in this period (i.e. round(25/7, 0)) (i.e. 3) and multiply by 5 (for work days) (i.e. 15).
Then take the total number of days mod 7 (i.e. 4) and work out what day of the week you are starting from (i.e. today is friday) and work out the number of weekend days to take (0, 1 or 2) from this number (i.e. day 2 and 3 are weekends) (i.e. 2) then take it from the number (giving you 2).
Then add them up (i.e. 15 + 2 = 7).

I'll come up with a function that does this if you want but someone else may be able to do is more easily and mine will involve using other cells to store values.

Thanks Oli,

I was mis-informed by someone, who told me the analysis tool kit was actually a developer pack, where in reality ticking the add-in box did the trick.

Google is my friend!