Forum Discussion
date conversion not responding
I am trying to format a date column to MM/YYYY, however, none of my attempts to change the column are working.
I have attempted that several times, I should mention that the cell is concatenated. I am not sure if that is a problem. But I have attempted that format step several times to no avail.
Could you attach a sample workbook without sensitive data?
This isn't going to work. Excel doesn't recognize dates before the year 1900.
If you want to display the values as MM/YYYY, use
=D2&"/"&C2
You won't be able to perform date calculations with these values for the reason mentioned above.
- Thanks, that solved my problem