Thread: Date LookUp
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jordan Jordan is offline
external usenet poster
 
Posts: 144
Default Date LookUp

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.