Hello,
I have a range with dates ( Format 3/25/2010). The range includes different years.
How can I count all rows from March 2010?
Thanks for the help!
Hello,
I have a range with dates ( Format 3/25/2010). The range includes different years.
How can I count all rows from March 2010?
Thanks for the help!
Last edited by Bob@Sun; 08-18-2010 at 05:21 AM.
If dates are sorted ascending:
You can try this: =COUNTIF(A:A, ">="&"1.3.2010")
Or define cell where you can write any date:
=COUNTIF(A:A, ">="&C1)
Never use Merged Cells in Excel
Thanks a lot! It does the job!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks