MS Excel 2000 formulae

  Roland Butter 19:02 26 Jun 03

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 03

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 03

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

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

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…