Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of data that includes information such as; Name, Policy Number,
Original Effective Date, Status and Cancellation Date. There is other information as well. I am trying to count how many policys I had active in each month since January of 2003. So if a policy has an Orginal Effective Date of 03/01/2003 and then was cancelled in 04/01/2005, that policy would have a count of 1 for each month it was active. I need to show the information in a grid something like this. Jan Feb Mar etc. 2003 55 56 67 2004 70 66 42 2005 75 65 60 The problem I'm having is each row needs to be counted for each month it was active. Not sure how to handle this. Hope this makes sense. Thanks for any help you might be able to give me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working with dates | Excel Discussion (Misc queries) | |||
Working with dates | Excel Worksheet Functions | |||
working with dates | Excel Discussion (Misc queries) | |||
Working with dates | Excel Worksheet Functions | |||
working with dates | Excel Worksheet Functions |