|First, before you do anything, make sure it is a real DATE, |
not a TEXT string that looks like a Date.
To check, select your cell with the date
Right Click your mouse and select Format Cells
Select the Number TAB
You should have a 5 digit number, if you do not, then you do not have a real DATE, you have a TEXT string that looks like a Date.