month year function

mcarter973 · May 9th, 2002, 10:15 AM

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. · May 9th, 2002, 10:20 AM

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 · May 9th, 2002, 10:20 AM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 10:15 AM	#1
mcarter973 Board Regular Join Date: Mar 2002 Posts: 83	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.

May 9th, 2002, 10:20 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]