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...
Hi Daniel,
For the rule formula use
=OR(DAY($D7)=1,DAY($D7)=21,DAY($D7)=31)
etc., and apply the rule to your entire range