So the original data set is Column B. The intent is to create a custom column A and somehow apply a formula. First step is to referecne only the date cells and paste them in column A. Second Step is Goto>Special>BlankCells> then the cells get selected and then click uparrow and then ctrl+enter. It reference the above cell to the blank ones. How can we get this logic here.?