| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Count dates
Hi
I have column a in which various dates are entered. What I'd like to do is count the number of times there is any date that falls within a given week. e.g. say the week consists of start date Monday 12 Jan 2008 and ends Friday 16 Jan 2008 then I would like to do is calc how many times in column a there is a date that falls into that week. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Count dates
Try this:
=COUNTIF(A:A,"<="&DATE(2008,1,16))-COUNTIF(A:A,"<"&DATE(2008,1,12)) It would be better to put your dates in other cells (eg C1, D1), then you could have: =COUNTIF(A:A,"<="&D1)-COUNTIF(A:A,"<"&C1) where D1 is the later date. Hope this helps. Pete On Jan 28, 4:49*pm, Arceedee wrote: Hi I have column a in which various dates are entered. *What I'd like to do is count the number of times there is any date that falls within a given week. * e.g. say the week consists of start date Monday 12 Jan 2008 and ends Friday 16 Jan 2008 then I would like to do is calc how many times in column a there is a date that falls into that week. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Count dates
Spot on Pete, cheers
"Pete_UK" wrote: Try this: =COUNTIF(A:A,"<="&DATE(2008,1,16))-COUNTIF(A:A,"<"&DATE(2008,1,12)) It would be better to put your dates in other cells (eg C1, D1), then you could have: =COUNTIF(A:A,"<="&D1)-COUNTIF(A:A,"<"&C1) where D1 is the later date. Hope this helps. Pete On Jan 28, 4:49 pm, Arceedee wrote: Hi I have column a in which various dates are entered. What I'd like to do is count the number of times there is any date that falls within a given week. e.g. say the week consists of start date Monday 12 Jan 2008 and ends Friday 16 Jan 2008 then I would like to do is calc how many times in column a there is a date that falls into that week. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Count dates
You're welcome - thanks for feeding back.
Pete On Jan 28, 5:51*pm, Arceedee wrote: Spot on Pete, cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with dates!! Excel 2003 | Excel Discussion (Misc queries) | |||
| Count widgets between two dates - Excel 2003 | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
| count dates in excel | Excel Discussion (Misc queries) | |||
Linear Mode
