Hi,

Is it possible to use a formula to calculate a cell value based on dates. One fixed, and one variable?

The Problem.

I allocate £100 to cover a policy from 1st Jan to 31 March 2010
On the 15th February, I want to calculate how many days the policy has run, and the pro rata cost of the policy to that date inclusive.

I need to use the formula to calculate thousands of policies. The variable date is the start date, and the fixed date would be say 15th February.

Many thanks in advance....

Sai