by Rajesh Saraogi | Jun 14, 2020 | Formula & Functions, Text Functions
Goal: To generate Ordinal Number and Ordinal Date in excel. An Ordinal Number is a number that tells the position of something in a list, such as 1st, 2nd, 3rd, 4th, 5th etc. An Ordinal Date denotes the position of a day in a given month and year; e.g., 8th June, 2020...