#excelformula #excelformulas #excel365

Hello Friends,

In this video, we have explained how to get Quick date formats using formula in single cell. From a date column, we have got the day number, day name (both short and full), month number and name, year, and even the week number in the year. Moreover, you aim to include specialized formats like SAP date format also. We have used HSTACK, TEXT, LAMBDA and MAP function to achieve this.

Download the practice file from below link:
https://www.pk-anexcelexpert.com/quic...

Subscribe our new YouTube Channel:
   / @neotechnavigators  

Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
   • Project Plan(Gantt Chart) in excel  

Download our free Excel utility Tool and improve your productivity:
https://www.pk-anexcelexpert.com/pks-...

See our Excel Products:
https://www.pk-anexcelexpert.com/prod...

Visit to learn more:
Chart and Visualizations: https://www.pk-anexcelexpert.com/cate...
VBA Course: https://www.pk-anexcelexpert.com/vba/
Download useful Templates: https://www.pk-anexcelexpert.com/cate...
Dashboards: https://www.pk-anexcelexpert.com/exce...

Watch the best info-graphics and dynamic charts from below link:
   • Dynamic Graphs  

Learn and free download best excel Dashboard template:
   • Excel Dashboards  

Learn Step by Step VBA:
   • VBA Tutorial  

Website:
https://WWW.PK-AnExcelExpert.com

Facebook:
  / pkanexcelexpert  

Telegram:
https://t.me/joinchat/AAAAAE2OnviiEk5...

Pinterest:
  / pkanexcelexpert  

LinkedIn:
  / pk-anexcelexpert  

Twitter:
  / priyendra_kumar  

Instagram:
  / pkanexcelexpert  

Visit our Amazon Store
https://www.amazon.in/shop/pkanexcele...