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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5