Count cells with a date falling within a 30 day period.

R

Rob

I want to count the number of cells that have a date entered, in a period of
30 days, in a column with over a thousand cells. Some of the cells are blank
while others have random dates entered spanning a period of many years.

(I.e. How many cells, in the above mentioned column, have a date that falls
in the period between 21-Apr-2009 until 20-May-2009 ?)
 
J

Jacob Skaria

Dear Rob

Another way using COUNTIF(). With dates in Column C in date format..

=COUNTIF(C:C,">"&DATE(2009,4,21))-COUNTIF(C:C,">"&DATE(2009,5,20))

If this post helps click Yes
 

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

Count no. of occurance in 2 dynamic columns within a data period 7
Counting cells with specific month in 7
formulas to count dates 2
Extracting dates from a String 8
COUNTIFS with a date for criteria... 1
Start Day of Bi-Monthly Pay Period 9
EXCEL COUNTING HELP 3
number of week days in a period of time 5

Top