Quick custom date formats

 

A while ago I wrote a post on how to use custom formatting in excel. Let’s take a look at some interesting custom formatting codes for dates

Here are the codes

Quick custom date formats1

 

 

 

 

 

 

 

 

 

 

Note that : The custom codes are written in the format cells dialogue box (shortcut Ctrl + 1) under the Custom Category. You can play around with more date formats by combining different date character codes

Here is a quick summary of character codes and display comments

Quick custom date formats2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI