MS Excel 2000 formulae

  Roland Butter 19:02 26 Jun 2003

I need to obtain a formula for Excel to calc the number of mon-fri days an advert has been posted out for. So for eg. I advertise the sale of an item on 22 Jan the close date is 31st Jan but the item is actually sold 27th Jan. I then need to know how many days it took to sell (but I want to exclude Sat & Sun from the calc.)
Someone is smart enough to know this!

  Stealth_Mode 19:17 26 Jun 2003

The Analysis Toolpack, which is NOT installed by default, has this function:


where C4 contains the start date and D4 the end date.

  Roland Butter 20:05 26 Jun 2003

Stealth_Mode............I'm not worthy!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?