Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to keep a running count of how many oustanding items I
have. Column A has an "In" date Column B has an "Out" date In Column C I would like to add up how many items in A are before the out date in B. If A1:A5 = 3/1/06, 3/13/06, 3/8/06, 3/17/06, 4/6/06 and B1:B5 = " ", 3/24/06, 3/24/06, " ", 5/11/06 where " " is a blank cell C1:C5 = 1, 2, 3, 4, 3 I don't think that the COUNTIF function is the answer because the dates in B can be manually entered at a later date. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting the number of times a certain date appers | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
Date converted to Text Number | Excel Discussion (Misc queries) | |||
count number occurring within specific date range | Excel Worksheet Functions | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions |