Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, i have dates in one column cells (please see below)
10/06/2005 24/06/2005 03/08/2005 23/08/2005 18/09/2005 21/09/2005 28/09/2005 30/09/2005 05/10/2005 08/10/2005 18/10/2005 19/10/2005 02/11/2005 22/11/2005 26/11/2005 06/12/2005 16/12/2005 21/12/2005 i need a formula in next cell of each date to count the dates which have same month like in top two dates i have month 6 so formula should go throw all dates and see which dates are have month 6 and count them and count result should come to 2 as we got only two dates which are in month 6. and fourmula should also do same with other dates. i am trying to count the total of all those dates which have same months. Please if anybody can help. i dont need macro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count total dates for each month | Excel Discussion (Misc queries) | |||
count the occurance of a particular month in a column of dates | Excel Worksheet Functions | |||
Count the dates in a month | Excel Discussion (Misc queries) | |||
Count dates for previous month | Excel Worksheet Functions | |||
count dates within range by year and month | Excel Worksheet Functions |