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. |
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. |
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. |
Excel 2003 - Count dates
You're welcome - thanks for feeding back.
Pete On Jan 28, 5:51*pm, Arceedee wrote: Spot on Pete, cheers |
All times are GMT +1. The time now is 01:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com