Sometimes we need to use a custom date format which is not as per standard date formats. As you know we are blessed with custom formatting so you can create a custom date with a regular date serial number.
The benefit of a custom format is you don’t need to change the actual date serial number, which means you can those dates further in calculations.
So today, I’d like to share with you some of my favorite custom date formats which can help you present dates in a unique way.
How to use these Custom Date Formats
For all the formats which I have mentioned above, you need to follow the below steps.
- Select the cell where you want to apply the format.
- Now, press right-click and select “Format Cell”. Or you can also use a keyboard shortcut Ctrl + 1 to open format cell options.
- After that select custom and enter the format in the input bar and click OK.
This one is my favorite. If you are working on some dates where you want to get the day name only, this custom date format can help you.
And, if you want to get the day name in short form, you can use the below format.
Just like the day name if you want to get the day number you can use this custom format.
This custom date format will help you to get the month name for your date value. And, you can also add some custom text as per your requirement.
"Current Month is:" mmmm
Date with a Day Name
This format gives helps you with a date with a day name at the end.
Long Textual Date
And, if you want long textual data you can do this by using the below format.
"Today is Day" d", Month" m "& Year" yyyy.
Now tell me one thing. Do you have any format which you use? Share with me in the comment section.