Hi All,
Is there an easy way of counting the number of instances certain dates appear in a range?
I am using this formula:
{=(COUNTIF(LABS!$A$5:$A$21,">=1/5/2006")-COUNTIF(LABS!$A$5:$A$21,">=1/6/2006"))}
to count the number of times any date in May 2006 appears in the range.
It seems overly complicated!
Any suggestions?
Is there an easy way of counting the number of instances certain dates appear in a range?
I am using this formula:
{=(COUNTIF(LABS!$A$5:$A$21,">=1/5/2006")-COUNTIF(LABS!$A$5:$A$21,">=1/6/2006"))}
to count the number of times any date in May 2006 appears in the range.
It seems overly complicated!
Any suggestions?