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...
By the way, you don't need 4th rule. Apply custom format d"th" mmmm yyy to your entire range and after that add three conditional formatting rules for 1st, 2nd and 3rd
Attached.
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.
