Another approach to consider is to take the MAX of the start date and the
quarter start date and subtract that from the MIN of the end date and the
quarter end date.
--
Gary''s Student


"TP" wrote:

Roger,

I cant get either of the above to work. I am trying to calculate the
number of days in one range that fall in another range. It is for the
purposes of insurance, there are several policies that start at
different time throughout the year, but for accounting purposes the
quarters remain rigid to the cal. year.

so how do i calcualate how many days fall in q1 of2 006 from a policy
that say incepts on the 1/6/05 and expires on 31/05/2006

Thanks for all your help