For example you have a series of dates (such as 2016/1/15), and you need to show these dates as abbreviated day of week (such as Fri or F) or abbreviated month (such as Jan or J), how could you quickly solve it in Excel? This article collects some easy workarounds to figure out this problem:

More details:
https://www.extendoffice.com/documents/excel/3463-excel-date-format-abbreviated-day-of-week-month.html

Please take the opportunity to connect and share this video with your friends and family if you find it useful.