| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| Date Calculation to exclude weekends | Excel Worksheet Functions | |||
| Due Date Calculation? | New Users to Excel | |||
Hybrid Mode
