month year function

[mcarter973]

I have dates in column A, values in column B, daily % change in column C, monthly % change in column D and YTD % change in column D. Values are entered daily.

Is there a formula that will allow me to copy down the formula w/o changing cell reference for the month end or year end dates. for example, for monthly % change, Apr 8 will use the value from Mar 31 and May 15 will use the value from Apr 30 - but this requires a manual cell reference change from the value in the Mar 31 cell to the value in the Apr 30 cell.

 

[Mark W.]

Use =EOMONTH(datevalue,-1) and MATCH to find the value in your list
This message was edited by Mark W. on 2002-05-09 09:20

 

[Aladin Akyurek]

On 2002-05-09 09:15, mcarter973 wrote:
I have dates in column A, values in column B, daily % change in column C, monthly % change in column D and YTD % change in column D. Values are entered daily.

Is there a formula that will allow me to copy down the formula w/o changing cell reference for the month end or year end dates. for example, for monthly % change, Apr 8 will use the value from Mar 31 and May 15 will use the value from Apr 30 - but this requires a manual cell reference change from the value in the Mar 31 cell to the value in the Apr 30 cell.

=EOMONTH(A1,-1)

where A1 houses a date like 8-Apr-02.