Hi, I have date data that are texts and I have to convert them into dates. All other days are okay except this year which has 29 Feb. The formula I'm using to convert text to date is =DATE(RIGHT([@day],4),MID([@day],4,2),LEFT([@day],2)).
If someone can help me out would be much appreciated!
If someone can help me out would be much appreciated!