Hi all,
I thought this would be a straightforward exercise. I have a column that is a YEAR, but it's a GENERAL data type. I need to convert that to a date, basically the last date of the year, 12/31/2018.
example; 2018 --> 12/31/2018
I tried to use CONCANTENATE, but when I use the formula in the first cell, I grip it and copy all the way down the column it just copy's the same value, 12/31/2018.
Thanks for any help,
Bookmarks