Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countin Dates
Hi
I have a colum which contains dates in format mmm-yy format In the first row, I would like to count the number of instances where the month and year is equal to the current month and year. Is this possible please? Tks S |
#2
|
|||
|
|||
Steve Enter this as an array formula (Ctrl+Shift+Enter) =SUM(IF(MONTH(B5:B34)=MONTH(NOW()),IF(YEAR(B5:B34) =YEAR(NOW()),1,0),0)) dates in range B5:B34 This formula will count the number of dates that have the same month and year as today. Hope this helps. nick "Steve J" wrote in message ... Hi I have a colum which contains dates in format mmm-yy format In the first row, I would like to count the number of instances where the month and year is equal to the current month and year. Is this possible please? Tks S |
#3
|
|||
|
|||
-- HTH Bob Phillips "Steve J" wrote in message ... Hi I have a colum which contains dates in format mmm-yy format In the first row, I would like to count the number of instances where the month and year is equal to the current month and year. Is this possible please? Tks S |
#4
|
|||
|
|||
=SUMPRODUCT(--(TEXT(A1:A20,"yymm")=TEXT(TODAY(),"yymm")))
-- HTH Bob Phillips "Steve J" wrote in message ... Hi I have a colum which contains dates in format mmm-yy format In the first row, I would like to count the number of instances where the month and year is equal to the current month and year. Is this possible please? Tks S |
#5
|
|||
|
|||
Hi Steve,
Just another one, =SUMPRODUCT(--(A1:A20-DAY(A1:A20)=TODAY()-DAY(TODAY()))) Regards, Daniel M. "Steve J" wrote in message ... Hi I have a colum which contains dates in format mmm-yy format In the first row, I would like to count the number of instances where the month and year is equal to the current month and year. Is this possible please? Tks S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting Dates | Excel Worksheet Functions | |||
How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) |