The cell value that i gave was referring to the Column heading. It was reading from cell B6 which has the value DATE.