Custom Function for an Ordinal Date

A while ago I posted about creating an ordinal (1st, 2nd etc) for a date. With the inclusion of the LAMBDA function I thought I would create a custom function to simplify the process.

If you are new to custom functions you may want to review the link below which goes into detail.

As you can see from the image below the formula to display a date with an ordinal is quite complex.

This is a perfect use case for a custom function.

In the image below we have the LAMBDA version used for testing.

To create the custom function, we need a range name that uses the LAMBDA – see image below.

And finally we have a simplified way to display an ordinal date.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.