Published on
Written by Jacky Chou

# Adding Ordinal Notation To Dates In Excel

## Key Takeaway:

• Adding ordinal notation to dates in Excel can improve the readability and clarity of data.
• Ordinal notation refers to the use of suffixes like st, nd, rd, or th after a number to indicate its position in a sequence.
• There are two methods to add ordinal notation to dates in Excel: applying custom number format or using the DAY function and concatenating with the appropriate suffix.

Do you want to make your Excel spreadsheet dates more meaningful? Adding ordinal notation is a great way to make them stand out! Make work easier and save time by following this guide to quickly apply ordinal notation to your Excel dates.

## Adding ordinal notation to dates

Gaining an understanding of ordinal notation and why it’s important to use it can be achieved in two steps. Firstly, comprehend ordinal notation. Secondly, recognize the significance of using ordinal notation in Excel. This helps you add ordinal notation to dates.

Image credits: chouprojects.com by Harry Duncun

### Understanding ordinal notation

Ordinal notation refers to the numerical suffix used in dates to indicate a specific day’s position, particularly when counting upward from the first day of the month. This often includes abbreviations like ‘st’ or ‘th.’ Its usage follows a set order that is standard across countries and cultures worldwide.

As an example, June 22nd, July 5th, and October 12th are all examples of ordinal notations in dates. They primarily serve as a means to add clarity, improve readability and communication within the context of written content or communications.

While there is no one definitive rule on how to utilize ordinal notation in dates, it remains unchanged as an essential aspect of how we interpret written material every day. For instance, when it comes to correspondences for official purposes such as reports or legal documents – using this particular notation format can reduce errors that could potentially crop up due to misinterpretation.

Ordinal notation has been used for centuries and is still widely popular today due to its simplicity and effectiveness in providing distinguishing unique counting systems for events leading up to significant occurrences like anniversaries or birthday celebrations.

Using ordinal notation may seem small, but it’s a big step towards preventing your boss from thinking you submitted a report from 2001.

### Importance of using ordinal notation

Using ordinal notation in dates is crucial for communication and documentation purposes. It adds specificity and uniqueness to a date, making it more informative and easier to distinguish between different dates. For instance, instead of writing “June 1st”, using “June 1st” conveys the date more accurately as well as distinguishes its context from other days in June. Communicating with clarity is important, and hence using ordinal notation helps an audience understand the exact day of an event without any confusion.

By including ordinal notation, it not only conveys a professional tone but also shows attention to detail by ensuring that the date’s context is understood explicitly. This format is especially useful when documenting or archiving important records where precision should be at its highest possible level. Not only does it create a systematic approach towards maintaining records but also provides ease for future reference.

It may be easy to overlook the importance of ordinal notation in dates; however, this small change to document formatting can significantly impact the communication process’s accuracy. Inaccurate documentation could lead to devastating consequences like discrepancies of payments or mistimed medical procedures. Hence including ordinal notation is necessary wherever precision is required.

In today’s world, where communicational brevity has made abbreviations prevalent such as ASAP (as soon as possible), ISO (In search of), etc., not utilizing ordinal notation may lead to misinterpretation for international audiences unfamiliar with US-based nomenclature. Using this convention helps people who have different backgrounds quickly understand your intended meaning.

Ensure that your documents communicate information correctly and without ambiguity by using ordinal notation. By using this practice, you will join others in providing clear communications with those around us that understand our place in history as well as preserve events for future generations’ reference. Don’t risk your goals due to inadequate documentation; start using a systemized method today!

Don’t just settle for boring dates, give them some sass with ordinal notation in Excel.

## Steps to add ordinal notation to dates in Excel

To add ordinal notation to dates in Excel, try these solutions:

1. Applying custom number format.
2. Using the DAY function and concatenating with the appropriate suffix.

By applying the custom number format, you can add the suffix to the date. The DAY function enables you to extract the day and attach the right suffix.

Image credits: chouprojects.com by Harry Woodhock

### Applying custom number format

To format dates with ordinal notation in Excel, you can apply a custom number format. This will help display the date in the desired format and ensure that it conforms to your requirements.

Follow these six steps to apply custom number format:

1. Select the cell or range which contains the date
2. Go to “Format Cells”
3. Click on “Custom” category and scroll down until you reach “Type”
4. In the “Type” field, enter this code: `"dddd mmmm d\\, yyyy;@"`
5. Click “OK”
6. You may now see a correctly formatted date

In addition to using “~st”, “~nd”, “~rd”, and “~th” to indicate ordinals, there are other advanced techniques like macros that one can use for more customization.

Pro Tip: You can also use conditional formatting that will add ordinal notation automatically based on the day of the month.

Make your dates feel fancier than you do on a Friday night by using the DAY function and concatenating with the appropriate suffix.

### Using the DAY function and concatenating with the appropriate suffix

To include ordinal notation with dates in Excel, you can use the DAY function and concatenate it with the appropriate suffix.

For a step-by-step guide on how to implement this method:

1. Select the cell where you want to enter the date.
2. Enter the formula “=DAY(cell)” and replace “cell” with the cell reference that contains your date.
3. Add an “&” symbol between the DAY function and the ordinal suffix so that it concatenates them together. For example, “=DAY(cell)&IF(OR(DAY(cell)=11,DAY(cell)=12,DAY(cell)=13),"th",IF(MOD(DAY(cell),10)=1,"st",IF(MOD(DAY(cell),10)=2,"nd",IF(MOD(DAY(cell),10)=3,"rd","th"))))”.
4. Press “Enter,” and you will see your date with its corresponding ordinal notation!

It is important to note that with this method, there are different cases that need special consideration, such as dates ending in 1st, 2nd, or 3rd and dates between 11-13 that end in “th.”

A true fact: Excel was first released in 1985 for Mac OS computers by Microsoft Corporation.

• ✅ Ordinal notation refers to adding “st”, “nd”, “rd”, or “th” to a number to indicate its position in a sequence. (Source: HubSpot)
• ✅ In Excel, the “DAY” function can be used with an “&” operator and a formula to add ordinal notation to dates. (Source: Excel Easy)
• ✅ The formula for adding ordinal notation to a date in Excel looks like this: =DAY(date)&IF(OR(DAY(date)={11,12,13}),”th”,CHOOSE(RIGHT(DAY(date)), “st”, “nd”, “rd”, “th”)) (Source: Ablebits)
• ✅ The resulting formula will display the date with the appropriate ordinal notation, such as “1st”, “2nd”, “3rd”, “4th”, etc. (Source: Excel Campus)
• ✅ Adding ordinal notation to dates in Excel can make them easier to read and understand, especially in reports or presentations. (Source: Spreadsheet Planet)

### What is Adding Ordinal Notation to Dates in Excel?

Adding Ordinal Notation to Dates in Excel means adding the “st”, “nd”, “rd”, or “th” to the end of a date to indicate its position in a month.

### Why Should I Add Ordinal Notation to Dates in Excel?

Adding Ordinal Notation to Dates in Excel can make your document more professional and easier to understand by using proper grammar and punctuation.

### How Can I Add Ordinal Notation to Dates in Excel?

You can add ordinal notation to dates in Excel by using the TEXT function. The exact formula will depend on your specific date format and the language setting of your Excel program.

### What are the Different Ordinal Notations?

The different ordinal notations are “st” for 1st, “nd” for 2nd, “rd” for 3rd, and “th” for all other numbers. For example, June 1 would be represented as “June 1st” while June 13 would be represented as “June 13th”.

### Is it Possible to Add Ordinal Notation to Dates in Other Programs Besides Excel?

Yes, adding ordinal notation to dates is a standard function in many spreadsheet programs like Google Sheets and Apple Numbers, as well as in word processing programs like Microsoft Word.

### Why is it Important to Use Correct Grammar and Punctuation in Business Documents?

Using correct grammar and punctuation in business documents can make your organization look more professional and reliable, and can also ensure that the information being communicated is clear and easily understood.

## Related Articles

### Incrementing References By Multiples When Copying Formulas In Excel

Key Takeaways: There are two types of references in Excel ...

### Inserting A Row Or Column In Excel

Key Takeaway: Inserting a row in Excel is easy: Select ...

### Inserting And Deleting Rows In A Protected Worksheet In Excel

Key Takeaway: Inserting and deleting rows in a protected worksheet ...