How to dynamic the suffixes on dates (1st, 2nd, 3rd, 4th etc) in excel
Is there any way to get the suffixes on dates.
"A" column contains date and I need the required format in "B" column as mentioned below
A1: 6/1/2024 B1: 01st Jun 2024
A2: 6/9/2024 B2: 09th Jun 2024
A3: 6/22/2024 B3: 22nd Jun 2024.
As per my knowledge I can do it by taking helper column & I can do Vlookup. Is there any other method to do the same??
Thank you