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

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)