Dates Dates and more Dates

[Frick]

Range c8:r8 has first day of year dates. The C8 has date 1/1/05 all remaning col's have
(DATE(YEAR(c8)+1,MONTH(c8),DAY(c8)) copied across.

Range c10:r10 has dollar amounts such as $610.25


Range c25:ad25 has dates which are the 1st day of each month, such as 5/1/04 These dates are
formula driven with the first date entered and the remaining across col's referring to the formula
for the last day of the month in row 26.

Range c26:ad26 has dates which are the last day of each month, such as 5/31/04. These dates are
formula driven using the EOMONTH(__,0).

Range c31:ad31 has production amount numbers per month, such as 1458, 2385, 978 etc


The formula I need to generate in cells c32:ad32 is to:
Take the production amount and multiply times the dollar amount in row c10 so that the production
month is multipled times the dollar amount in the same year.

For example;

D08 = 1/1/06
D10 = $610.25

X25 = 3/1/06
X26 = 3/31/06

X31 = 100

X32 then should do the following:

100 x 610.25 = 61025.00 since the production amount is in March 06 it should then use the pricing
amount for Year 06, which is 610.25.

Hope that explains it.

Thanks, Frick

 

[J.E. McGimpsey]

One way:

X32: =X31*OFFSET($C10, 0, YEAR(X25)-YEAR($C8))