| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting of a date from a range of Cells
=COUNTIF(A1:A11,DATE(2009,1,3))
-- David Biddulph Manikandan wrote: ok...fine.... then how can i count a specific date from a range of data? "David Biddulph" wrote: =COUNTIF(A1:A10,"="&DATE(2009,1,1))-COUNTIF(A1:A10,""&DATE(2009,1,5)) if you want the date limits to be inclusive. If you want the limits to be exclusive, swap the and = signs. -- David Biddulph Manikandan wrote: I have a coulumn which contains somany dates in DD-MM-YY format. I want to count the number of cells which contain a range of dates like from 01.01.09 to 05.01.09 etc.. Please help me.. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting a date range | New Users to Excel | |||
| Counting items within a date range | New Users to Excel | |||
| counting cells that fall within a certain date range | Excel Discussion (Misc queries) | |||
| Counting Within a Date Range | Excel Worksheet Functions | |||
| Counting if between date range | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
