| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Dates
I have a list of dates in the following format MM/DD/YYYY.
1/11/2008 1/12/2008 1/30/2008 1/10/2008 1/10/2008 1/10/2008 1/12/2008 1/6/2008 I want to know how many times a date falls in-between a certain week. For instance, countif(range,"=1/1/2008","<=1/6/2008"). It should be 1. Any help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Dates
=SUMPRODUCT(A2:A100=startdate)-SUMPRODUCT(A2:A100enddate)
-- John C "Matthew Tyrus" wrote: I have a list of dates in the following format MM/DD/YYYY. 1/11/2008 1/12/2008 1/30/2008 1/10/2008 1/10/2008 1/10/2008 1/12/2008 1/6/2008 I want to know how many times a date falls in-between a certain week. For instance, countif(range,"=1/1/2008","<=1/6/2008"). It should be 1. Any help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Dates
Try this:
Enter you date boundaries in cells: C1 = 1/1/2008 D1 = 1/6/2008 =COUNTIF(A1:A8,"="&C1)-COUNTIF(A1:A8,""&D1) -- Biff Microsoft Excel MVP "Matthew Tyrus" wrote in message ... I have a list of dates in the following format MM/DD/YYYY. 1/11/2008 1/12/2008 1/30/2008 1/10/2008 1/10/2008 1/10/2008 1/12/2008 1/6/2008 I want to know how many times a date falls in-between a certain week. For instance, countif(range,"=1/1/2008","<=1/6/2008"). It should be 1. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count on dates | Excel Worksheet Functions | |||
| I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
| Count dates | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| How do a count dates? | Excel Discussion (Misc queries) | |||
Linear Mode
