Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting the number of dates?
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 |
#2
|
|||
|
|||
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) "aaronwexler" wrote in message ... 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 |
#3
|
|||
|
|||
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? "Bob Phillips" wrote: 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) "aaronwexler" wrote in message ... 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 |
#4
|
|||
|
|||
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) "aaronwexler" wrote in message ... 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? "Bob Phillips" wrote: 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) "aaronwexler" wrote in message ... 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 |
#5
|
|||
|
|||
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. "Bob Phillips" wrote: 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) "aaronwexler" wrote in message ... 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? "Bob Phillips" wrote: 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) "aaronwexler" wrote in message ... 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 |
#6
|
|||
|
|||
That one too?
-- HTH RP (remove nothere from the email address if mailing direct) "aaronwexler" wrote in message ... 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. "Bob Phillips" wrote: 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) "aaronwexler" wrote in message ... 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? "Bob Phillips" wrote: 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) "aaronwexler" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating number of weeks from two dates | Excel Discussion (Misc queries) | |||
counting based ona number of variables. | Excel Worksheet Functions | |||
Counting the number of rows | Excel Worksheet Functions | |||
Counting Dates | Excel Worksheet Functions | |||
Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions |