Counting the number of dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a worksheet of mine I have a bunch of dates in column A in the format
dd/mm/yyyy. I also have data in between the dates in that column and I was
wondering if there was a formula that will count the number of dates.

Thanks Aaron
 
If the other data is not numbers you can use

=SUMPRODUCT(--ISNUMBER(A1:A100))

if there could be other numbers, then if you know the start and end dates
you could use

=SUMPRODUCT(--(A1:A100>=DATE(2005,1,1)),--(A1:A100<=DATE(2005,12,31)))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks Bob, I tried the second formula because there are other number in
column A, but I still just get a zero as an answer. Does the date have to be
in a certain format?
 
It has to be a date not text. Where do the dates come from?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
The dates are dates not text. I type in 8/12 for example and it converts it
to a date. I double checked in the "format" "cell" menu and they are dates.
I'm not sure what you mean by where they come from. I am keeping track of my
day trades by day, if thats what you mean.
 
That one too?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top