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
To all the formats which I have mentioned above you need to follow below steps.
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 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 month name for your date value. And, you can also add some custom text as per your requirement.
“Current Month is:” mmmm
This format gives help you a date with a day name in the end.
And, if you want a long textual date you can do this by using this 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.
Must Learn Excel Tutorials