A B C
3/17/2016 20 2016
2/24/2016 27 2016
1/21/2016 24 2016
12/17/2016 21 2015
1. I am trying to get Column A and B to have the year from column C which is formatted as general.
2. I want column B to have the month from column A and the day from column B which is formated as general text.
1:So D5 should be 12/17/15
2. E5 Should be 12/21/15
Bookmarks