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
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
