# Count on Date Range

1. ## Count on Date Range

I have defined a name on a list in have in my worksheet

``Please Login or Register  to view this content.``

I now want to count how many entries there are in that list, that have a date less that todays date - 100 days.

i tried this

``Please Login or Register  to view this content.``
but it doesn't return any values. There are 5 dates that met the criteria.
i have attached my spreadsheet, and hightlighted the 5 dates that met the criteria

Any help greatly appreciated

2. ## Re: Count on Date Range

Maybe COUNTIF instead of just COUNT.

3. ## Re: Count on Date Range

Hi try this
``Please Login or Register  to view this content.``

4. ## Re: Count on Date Range

I have just tried COUNTIF and even put the date formula in another cell that i referenced. the cell A1 has the following formula

``Please Login or Register  to view this content.``
then i used the following formula
``Please Login or Register  to view this content.``
but this still returned a 0 Value

5. ## Re: Count on Date Range

Hi

Corect result is 6. Not 5

=COUNTIF(JNM_Over100,"<"&TODAY()-100)

6. ## Re: Count on Date Range

=COUNTIF(JNM_Over100,"<"&A1)

7. ## Re: Count on Date Range

Date Value.xls

Solved Bro

Key formula : =SUMIF(D4:D23,">"&D28&"",I4:I23)

where D28 is the date with which u wanna check .. u can use today () also ryt in D28

I4:I23 is a new colum dat contains 1 only for counting

cheers

8. ## Re: Count on Date Range

Excellent, thank you that worked, and yes, my counting ability is bad, hence why i need excel.

9. ## Re: Count on Date Range

.....and yes, my counting ability is bad, hence why i need excel.
Ha Ha....!

You are welcome.

Excel, never says lies!!!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1