Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Few, days back, I had explained about how to convert non-standard date formats to standard date formats in my post. But, Sometimes it is required that we use some off track date formats rather than using simple date formats. As we know, excel blessed us with highly flexible options & Custom Date Formats is one of them. So, today we will discuss some custom date formats.
This one is my favorite. If you are working on some date where you want to get the day name only, this custom date format will help you.
And, if you want to get the day name in short form, you can do it this way “It’s” ddd
Just like the day name if you want to get the day number in some custom way, you can use this custom date format.
This custom date format will help you to get month name for your date value. And, you can also add some custom text as per your requirement.
“Current Month is:” mmmm
You can change month name from long to short by using “Current Month is:” mmm or you can change or add prefix & suffix.
This format will help you to get a date with small day name in the end.
And, if you really want a long textual date you can do this by using this custom date format.
“Today is Day” d”, Month” m “& Year” yyyy.
In the end, If we talk about how much these custom date formats are useful. I only want to say one thing that these custom date formats mark their importance as per the situations. They are the hero of their day.
And, Finally if want to add some other custom date format in this list. Just hit the comment box.