| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count number of dates in a column that are within a month period..
I'm trying to write a function that will look at a column of dates (C2:C72)
and count the number that are between Nov 01 2007 and Nov 30 2007 (e.g.) I'm thinking that LOOKUP or IF function might work.. =LOOKUP("11/01/2007<date<11/31/2007",C2:C12) (this one doesn't count, and I can't figure out why it is not reading my dates as dates).... thanks much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the number of events in a 90 day period? | Excel Worksheet Functions | |||
| Count the dates in a month | Excel Discussion (Misc queries) | |||
| Count number of cells of a particular month in a column of dates | Excel Discussion (Misc queries) | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| Total number of each month in a column of dates | Excel Worksheet Functions | |||
Threaded Mode
