Counting number of days within a range.

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



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




------------------------------------------------
 
D

Dan E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Section and Page numbering 0
Finding the proper style field and the numbered paragraph value within the style 0
Count in a range of numbers 9
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Counting multiple occcurrences between date range 3
Sum of Numbers of a Rolling 6 month Period range 0
Finding the right style field in VBA 0

Top