Date Calculation
 

I need help with the following:

Column 'I' contains Annual Rental
Column 'M' contains Date Ceased

My end of financial year is 31 March 2007

I need to calculate the remaining days from 'Date Ceased' to 31 March 2007
then divide by the Annual Rental to show my savings for the remainder of the
year.

Grateful for any help.

Date Calculation
 

=("2007-03-31"-M2)/I2

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"AndyO_UK" wrote in message
...
I need help with the following:

Column 'I' contains Annual Rental
Column 'M' contains Date Ceased

My end of financial year is 31 March 2007

I need to calculate the remaining days from 'Date Ceased' to 31 March 2007
then divide by the Annual Rental to show my savings for the remainder of
the
year.

Grateful for any help.

Date Calculation
 

Hi Andy

=(DATE(2007,3,31)-M1)/365*I1

--
Regards

Roger Govier


"AndyO_UK" wrote in message
...
I need help with the following:

Column 'I' contains Annual Rental
Column 'M' contains Date Ceased

My end of financial year is 31 March 2007

I need to calculate the remaining days from 'Date Ceased' to 31 March
2007
then divide by the Annual Rental to show my savings for the remainder
of the
year.

Grateful for any help.