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.
|