Formula to Calaculate Cost Per Date

[LearnMeExcel]

hi
i have this table

Excel Workbook
	A	B	C	D	E	F
1	Information
2	Cont No.	Cont-Value	Start Date	End Date	Days	Cost Per Day
3	Cont-001	45000	19/06/2011	18/06/2012	365	123.288
4	Cont-002	25000	05/02/2011	04/02/2012	364	68.681
5	Cont-003	48000	10/02/2011	15/09/2011	217	221.198
6	Cont-004	12000	17/01/2011	16/01/2012	364	32.967
7	Cont-005	36000	25/11/2011	15/07/2012	233	154.506
8	Cont-006	75000	08/03/2011	10/06/2011	94	797.872
9	Cont-007	28000	06/03/2011	05/03/2012	365	76.712
10	Cont-008	42000	12/02/2011	11/02/2012	364	115.385
11	Cont-009	23500	19/12/2011	18/12/2012	365	64.384
12	Cont-010	48000	11/01/2011	10/01/2012	364	131.868
Sheet1

Excel 2010

Cell Formulas
Range	Formula
E3	=D3-C3
F3	=B3/E3

i want to calculate the cost for every month in 2011 and 2012 per day for every month
jan 31 day
feb 28 in 2011 and 29 in 2012
this is the other tabels

Excel Workbook
	G	H	I	J	K	L	M	N	O	P	Q	R
1	2011
2	Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11
3
4
5
6
7
8
9
10
11
12
Sheet1

Excel 2010

and this is for 2012

Excel Workbook
	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1	2012
2	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12
3
4
5
6
7
8
9
10
11
12
Sheet1

Excel 2010

 

[Peter_SSs]

For row 3. If you include both 19/06/2011 and 18/06/2012 then there are 366 days. Since your formula in E3 is giving 365, you must be excluding either the first day (19/06/2011) or the last day (18/06/2012) but you haven't said which. I have assumed excluding the first day. See if this formula in G3, copied across and down does what you want. It assumes G3, H3 etc actually contain the dates 1/01/2011, 1/02/2011 etc.

If this is not what you want, please give more details and perhaps some sample results for the data you have given above.

Excel Workbook
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
2	Start Date	End Date	Days	Cost Per Day	Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12
3	19/06/2011	18/06/2012	365	123.288						1356.2	3821.9	3821.9	3698.6	3821.9	3698.6	3821.9	3821.9	3575.3	3821.9	3698.6	3821.9	2219.2
4	5/02/2011	4/02/2012	364	68.681		1579.7	2129.1	2060.4	2129.1	2060.4	2129.1	2129.1	2060.4	2129.1	2060.4	2129.1	2129.1	274.73
5	10/02/2011	15/09/2011	217	221.198		3981.6	6857.1	6635.9	6857.1	6635.9	6857.1	6857.1	3318
6	17/01/2011	16/01/2012	364	32.967	461.54	923.08	1022	989.01	1022	989.01	1022	1022	989.01	1022	989.01	1022	527.47
7	25/11/2011	15/07/2012	233	154.506											772.53	4789.7	4789.7	4480.7	4789.7	4635.2	4789.7	4635.2	2317.6
8	8/03/2011	10/06/2011	94	797.872			18351	23936	24734	7978.7
9	6/03/2011	5/03/2012	365	76.712			1917.8	2301.4	2378.1	2301.4	2378.1	2378.1	2301.4	2378.1	2301.4	2378.1	2378.1	2224.7	383.56
10	12/02/2011	11/02/2012	364	115.385		1846.2	3576.9	3461.5	3576.9	3461.5	3576.9	3576.9	3461.5	3576.9	3461.5	3576.9	3576.9	1269.2
Distribute cost

 

[thunder_anger]

Question
if there are averages of prices every year can i take into consideration when calculating the cost per day because all the amounts are of 365 days not important being in the same year or date difference between two dates

i have a similar situation here but never solved i had to divide and isolate every year to be in a separate sheet

 

[Peter_SSs]

Question
if there are averages of prices every year can i take into consideration when calculating the cost per day because all the amounts are of 365 days not important being in the same year or date difference between two dates

i have a similar situation here but never solved i had to divide and isolate every year to be in a separate sheet

I'm afraid I do not understand that question. Could you re-phrase it and/or provide a small set of sample data and expected results to help clarify?

 

[thunder_anger]

simply

i have here about

808 days of sales
form 3/6/2000
to 2/8/2002
the prices of 2001 is higher than 2000 with 15%
the prices of 2002 is higher than 2001 with 7%
so
when i calculate the total cost of of the 808 days
there are duplicates of a certain item so when you calculate the cost of that item in the 808 days is there a method to tell that the price has increased with previous percentage in other words (item price is an argument) so when you say

totalcost = item price (which is changing) * 808 days
so is there a way to take such an idea into consideration??
hope i am clear

[URL="http://www.excel-jeanie-html.de/index.php?f=1"][/URL]

 

[thunder_anger]

is there a one formula to calculate that all