In column A I have dates in the format yyyymmdd. In column B is daily data (just weekdays). In column C are monthly dates(in format Jan-90), and in column D is monthly data covering the same overall time period as the daily data (ie, January 1990 to December 2010). I want each cell in column E to be the product of the daily value in column B times the corresponding monthly value in column D. As an example:
Column A Column B Column C Column D Column E
19900130 100 Jan-90 5 500
19900131 90 Feb-90 3 450
19900201 80 Mar-90 4 240
19900228 90 June-92 7 270
19900301 100 July-92 6 400
Please keep in mind that the daily data excludes weekend dates.