How to Create a Custom Date Format in Excel

You can create any date format you want. In this video I demonstrate how to change the date format for selected cells and how to reformat on-the-fly using a formula.

Add your questions and comments below. I read and respond to every comment personally.

And don't forget to subscribe and hit that bell to be the first to get notified when new videos are dropped.

USEFUL LINKS:

DOWNLOAD the demo spreadsheet

SHARE this video with your social network:

SUBSCRIBE if you want to see more content like this

Hire Jason to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching

ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.

LET'S CONNECT!

Have a fantastic day!

[JasonMorrell]

I trust that you found value in this video. Feel free to post your questions and feedback in the comments below. I read and respond to every comment. Have a fantastic day. Jason

[zerandervax]

Perfect, just what I was looking for. Thanks Muchly :0)

[truenewsH]

Thanks for the video .very usefull date and formating

[rahuljoseph]

Thanks for the video. I'm looking to represent a date in Fiscal year format. For example 06/31/2019 should show up as FY20. I was able to show it as FY19, could we do any mathematical operations like yy+1 to achieve this?

[adrianharris]

really useful. Is there a way to produce the date as say the 5th, 3rd, 28th, 2nd and so forth

[randomrandy]

Nice! But how do you add the "th" or the "rd" to those custom dates?

[Lilian.Chidinma.Nwafor]

Thank you for this. But my problem is how to conver 5 digits to date. D.mm.yy or m.dd.yy. please help

[jimdimakos]

how can you get the input mm/dd/yy or 7/11/22 to show as July 11, 22?

[henniebotha]

Unfortunately, even if my country is set to Aus, or South Africa, and I then set the format to dd-mmm, and then enter 12/10 (in other words, hey excel, I am typing the day first, then the month), this wonderful software converts it to 10-Dec :(