How to dynamic the suffixes on dates (1st, 2nd, 3rd, 4th etc) in excel
03:00 14 Jun 2024

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

excel excel-formula