LinkBack URL
About LinkBacks
I'd like help on the best way to count the number of times a date (mm/dd/yyyy) is entered in A1:A100.
Thank you!
I'd like help on the best way to count the number of times a date (mm/dd/yyyy) is entered in A1:A100.
Thank you!
1 way
Formula:
Please Login or Register to view this content.
2nd way
In DI type your date. Then use.
Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
We tried =COUNTIF(A2:A100,"01/01/2012"). It only counts if the date is actually typed in as 01/01/2012 .... our dates are sequential from 10/15/2013 forward. What's the reasoning for starting at A2 instead of A1?
And we didn't quite follow the second suggestion ....
More help on this please?!!!
What's the reasoning for starting at A2 instead of A1? i should imagine none! its just an example adjust ranges to suit your data
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks