Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates
How are parital months to be handled. For example 15 jan 2003 thru 15 feb
2003?? -- Gary''s Student - gsnu200759 "Jordan" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates
Thanks for the quick response. I actually use cheater columns to pull out
the month and year. If it was active at all in the month I need to count it. Thanks for your help. "Gary''s Student" wrote: How are parital months to be handled. For example 15 jan 2003 thru 15 feb 2003?? -- Gary''s Student - gsnu200759 "Jordan" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |