Counting number of days within a range.

  • Thread starter Thread starter Chandana
  • Start date Start date
C

Chandana

Hi,
I need to count the number of occurrences of any dates that fall
between a specific range of dates. For example:
find all the dates in a particular range and count the occurences from
date1 to date2.
Please help .
Thanks,
Chandana



------------------------------------------------




------------------------------------------------
 
Chandana,

With Column A containing the dates,
Cell C2 containing the start date
Cell C3 containing the end date

=COUNTIF(A:A,">=" & C2 ) - COUNTIF(A:A, ">" & C3)

Counts all cells equal to and larger than C2 and subtracts all
cells larger than C3

Dan E
 
Back
Top