Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting Dates
In a column, there are entries with dates (in MM/DD/YYYY format). How can I
count the number of cells that have dates in them? I do not want to input a criteria for the date. I just would like the number of cells that have any date in it. Thanks! |
#2
|
|||
|
|||
Tricky, because dates in Excel are just number of days since 01//01/1900, so
it is difficult to distinguish a date from any other positive integer number If you set limits on the dates, say since 1970, and up until 2010, you could use =SUMPRODUCT(--(A1:A1000=--"1970-01-01"),--(A1:A1000<=--"2011-01-01")) -- HTH Bob Phillips "MJMP" wrote in message ... In a column, there are entries with dates (in MM/DD/YYYY format). How can I count the number of cells that have dates in them? I do not want to input a criteria for the date. I just would like the number of cells that have any date in it. Thanks! |
#3
|
|||
|
|||
You can't really check if it is a date since dates are plain numbers
formatted as dates with date 0 on jAN 0 1900, however you can check for numbers in the range (there is a function called CELL("format",cell) but it is not reliable since if the format changes it will change as well =SUMPRODUCT(--(ISNUMBER(Range)) will count cells with numbers, if they are text you can use ISTEXT instead of ISNUMBER Regards, Peo Sjoblom "MJMP" wrote: In a column, there are entries with dates (in MM/DD/YYYY format). How can I count the number of cells that have dates in them? I do not want to input a criteria for the date. I just would like the number of cells that have any date in it. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting occurences of a specific day between two dates | Excel Worksheet Functions | |||
Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
How to Calculate Dates without counting the weekends | Excel Worksheet Functions | |||
Counting Dates less then today | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |