Hello
I have to work out how much money we owe a supplier. I have a report which in cell E2 i have a the start date. We then get 22 days free in which i have create a cell J2 I then want to find out from the end of the free days to the current day how many days have past and then i want to mutliply the number of days by a price to give me a total i.e:
Start Date Date Free Days Expire Cost Per Day No Days Total
31/10/2005 22/11/2005 £30 50 £1500
So in the cell number of days i have =(DATE(YEAR(E2),MONTH(E2),DAY(E2)+22))
Then in the total column i have =sum(now()-"No Days)*£30
The sum then returns £1515 which is wrong
Could anyone advise a formula on how to do this more efficent and correctly?
I have to work out how much money we owe a supplier. I have a report which in cell E2 i have a the start date. We then get 22 days free in which i have create a cell J2 I then want to find out from the end of the free days to the current day how many days have past and then i want to mutliply the number of days by a price to give me a total i.e:
Start Date Date Free Days Expire Cost Per Day No Days Total
31/10/2005 22/11/2005 £30 50 £1500
So in the cell number of days i have =(DATE(YEAR(E2),MONTH(E2),DAY(E2)+22))
Then in the total column i have =sum(now()-"No Days)*£30
The sum then returns £1515 which is wrong
Could anyone advise a formula on how to do this more efficent and correctly?