Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of instances before a certain date
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of instances before a certain date
one way
Sub countlessthan() For Each c In Range("d1:d5") If c < c.Offset(, 1) Then mc = mc + 1 Next c MsgBox mc End Sub -- Don Guillett SalesAid Software "JLH" wrote in message ups.com... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of instances before a certain date
How does one put a subroutine into Excel?
Don Guillett wrote: one way Sub countlessthan() For Each c In Range("d1:d5") If c < c.Offset(, 1) Then mc = mc + 1 Next c MsgBox mc End Sub -- Don Guillett SalesAid Software "JLH" wrote in message ups.com... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of instances before a certain date
How do I put the number in the cell vice having a msg box pop up with
the number? I want this to be a running count that is always visible for historical purposes. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of instances before a certain date
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |