I have extracted the date,month and year using left,right and mid and put the cell references in datevalue function but it is asking for only one arguement. I am unable to get the result.