Counting dates in a list

[L33]

Hi,
I found this handy formula some months ago on these messageboards:

=countif(Sheet1!B:B,">=01/03/08")-countif(Sheet1!B:B,">31/03/08")

It counts number of dates in a given list of dates within the specified period.

But I now want to replace the underlined sections with cell references - but whatever I try, Excel won't let me do that.

Basically, I want put dates in to two cells, use Networkdays to get working days, then deduct the number of days in a pre-defined list between those two dates aswell.

I know there's a holidays parameter on the Networkdays function, but I need to display this to users in a step by step fashion.


Any help much appreciated.

 

[DonkeyOte]

">="&cellref

encase operator in quotations and & to cell reference.

hope that helps.

 

[VoG]

Try a formula like

=COUNTIF(Sheet1!B:B,">="&A1)-COUNTIF(Sheet1!B:B,">"&A2)

where A1 and A2 house dates.

 

[Aladin Akyurek]

For example...

=COUNTIF(Sheet1:B:B,">="&F2)-COUNTIF(Sheet1!B:B,">"&G2)

where F2 <= G2.

 

[L33]

Genius! Many thanks.


Just have to work out why my Networkdays is suddenly returning the "#NAME?" error when it's been working fine until now.

 

[VoG]

Is the Analysis Toolpack ticked in Tools > Add-ins?

 

[L33]

It was, but I've just unticked it, closed down Excel, then opened it up again and ticked it again - it appears to be working ok now. Must have been a small bug.

Many thanks.