DIFFICULT: Converting monthly data into daily data, how

[sneeky]

Hi. I have two columns, one with a date every month for a couple of years (usually last day) and another column, with a value like. 0.23788 for that particular date. How do i break this down into a daily series with corresponding values. I think this is asking for some sort of regression or something, and data to be assumed from that as we not given a daily value and presume it from sort of maths/stats??? it's related to finance if that helps.
.............. SORRY I HAVE TO AMEND. IT'S NOT ASKING FOR THIS.

All it wants me to do, is break the month into days with the SAME value given for that month that's all. So if it is 0..2999 for 30th March - all days in march should have that value.
How would i do this - what formulas or similar can i do to break it down to days quickly with corresponding same value if the month is the same without manually typing it all in. 7
Thx

 

[sneeky]

Mark thanks a lot! Your last sumproduct worked excellently. However, i realised how difficult it is and need understand it better - which is going to take time, i need to become fluent at this and unfort. books are rubbish at explaining complex formulas. But honestly. lifesaver!

 

[MARK858]

It's not that difficult sumproduct checks if the criteria matches and returns an array of either true or false which the +0 converts to a 1 or 0.
So in the table below if we are testing for March 1999 then only row 4 matches both criteria and so 55 is the only answer returned.

Excel Workbook
	A	B	C	D	E	F
1		March	1999	multiply together	random numbers	returned
2	01/03/2000	1	0	0	22	0
3	27/02/1999	0	1	0	44	0
4	12/03/1999	1	1	1	55	55
5	06/01/1999	0	1	0	66	0
Sheet2