Forum Discussion
Date formats with a suffix
I have an excel sheet where I will be entering dates as I go, all within the same column. I would like these dates to be automatically formatted into full dates with a suffix(ie. 08/18 would be 1st A...
Thank you for your reply. Unfortunately, I still seem to be doing something wrong. I set the formatting for the whole column as you suggested and then set the rules separately for st, nd and rd but only the main formatting is happening.
Screenshot below of what I end up with:
Since you apply the rule to entire column D in the formulas it shall be D1 instead of D7 (first cell of the range to which you apply the rule)
Thank you so much! Works exactly as I expected it to.
You are welcome