Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to count the total Number of dates between two dates How?
I have a Date Column and want to count number of dates which fall between two
specified dates. i.e Date 01/20/08 i wish to count the number of dates in this column = 01/15/08 and 02/15/08 <=02/15/08. ffrom the example we should get the count as 3. 03/20/08 can Use please help me with the formula? 01/25/08 Thanks seshadri |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to count the total Number of dates between two dates How?
Try one of these.
Using cells to hold the date boundaries: C1 = 1/15/2008 D1 = 2/15/2008 Dates in column A =INDEX(FREQUENCY(A:A,C1:D1-{1,0}),2) =COUNTIF(A:A,"="&C1)-COUNTIF(A:A,""&D1) Format as GENERAL or NUMBER -- Biff Microsoft Excel MVP "seshu" wrote in message ... I have a Date Column and want to count number of dates which fall between two specified dates. i.e Date 01/20/08 i wish to count the number of dates in this column = 01/15/08 and 02/15/08 <=02/15/08. ffrom the example we should get the count as 3. 03/20/08 can Use please help me with the formula? 01/25/08 Thanks seshadri |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to count the total Number of dates between two dates How?
Thanks Verymuch for your Fast Responce Valko. It worked. Thanks again
Regards Seshadri "seshu" wrote: I have a Date Column and want to count number of dates which fall between two specified dates. i.e Date 01/20/08 i wish to count the number of dates in this column = 01/15/08 and 02/15/08 <=02/15/08. ffrom the example we should get the count as 3. 03/20/08 can Use please help me with the formula? 01/25/08 Thanks seshadri |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to count the total Number of dates between two dates How?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "seshu" wrote in message ... Thanks Verymuch for your Fast Responce Valko. It worked. Thanks again Regards Seshadri "seshu" wrote: I have a Date Column and want to count number of dates which fall between two specified dates. i.e Date 01/20/08 i wish to count the number of dates in this column = 01/15/08 and 02/15/08 <=02/15/08. ffrom the example we should get the count as 3. 03/20/08 can Use please help me with the formula? 01/25/08 Thanks seshadri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In a set of dates, can you count the number of Jan '07 instances? | Excel Worksheet Functions | |||
Count number of dates | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
How do i count number of weekdays between two dates? | Excel Worksheet Functions | |||
Total number of each month in a column of dates | Excel Worksheet Functions |