View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AndyO_UK AndyO_UK is offline
external usenet poster
 
Posts: 15
Default 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.