| 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 | |||
Hybrid Mode
