removing weekend dates

[allunderme]

Hi Everyone,

I have a simple calculation of one date minus another to produce a "lifecycle" of a process im monitoring.

I need to remove the weekends from this figure as they are technically not a working day.

Is there anyway of doing this?

Regards

Allun

 

[Jonmo1]

Try the NETWORKDAYS function.

If you have XL2003, you'd have to add the Analisys Toolpack from Tools - Addins.
In XL2007 + it's installed by default.

 

[allunderme]

Thank you Jonmo1

Working well now

 

[Jonmo1]

You're welcome.