alright, i had to use an add-in because I used the formula EOMONTH
(http://office.microsoft.com/en-us/as...090761033.aspx)

it's in the analysis toolpack

I'll just lay out what I did
In column A I had an incrementing date range. I put from today's date
till the 28th and pretended that was the last business day of this
month
In column B I had an exchange rate
in cell C1 I put in a date. I just put it as today so 7/21/2006
in cell d1 I put in the vlookup
=VLOOKUP(EOMONTH(C1,0),A1:B23,2,TRUE)
This will return the exchange rate beside 7/28/2006.

So in column C you could put a value for each month you're interested
in and change the formatting to custom MMM-YYYY or something like
that.

Hope that helps,
Mark


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563743