hmmm, not sure what you guys mean.
basically I need to make sure that the dates match for exchange rates and crude oil prices.
I have done up to April 2007. For example, in column A, April 21 and 22 have to be deleted because column D jumps from April 20 to April 23. (Crude oil markets don't open on weekends)
The results should be that all dates match up until Mar 15, 2011.
download file here:
http://www.sfu.ca/~lcheung/cny_jpy_e...ates_help.xlsx