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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Why ecommerce hasn't taken off on social media

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's expensive and powerful…