Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of policies that contains an Effective Date and a Cancellation
Date. I'm trying to do a count by month over the span of a couple of years of how many policys were active in the given month. For Example; May 2007 = 423 June 2007 = 427 and so on. I need to know if the month I am counting (May 2007) is between the Effective Date and the Cancellation Date and if it is to include that line item in the count (423). Any help will be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Lookup | Excel Discussion (Misc queries) | |||
Lookup MIN Date | Excel Worksheet Functions | |||
Lookup MIN Date | Excel Worksheet Functions | |||
Lookup MIN Date | Excel Worksheet Functions | |||
Lookup the date associated with a given value | Excel Discussion (Misc queries) |