Quick date formats using formula in single cell

#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:
www.pk-anexcelexpert.com/quic...
Subscribe our new RUclips Channel:
/ @neotechnavigators
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/pks-...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: 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:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Twitter:
/ priyendra_kumar
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@temyraverdana6421]

Thank a lot for this useful tips

[@PKAnExcelExpert]

Most welcome

[@muhmmedalhmed2559]

You have successfully subscribed ♥️🌹

[@unnikrishnansanthosh]

i was not aware of hstack functions got such capability, thank you for sharing

[@nadermounir8228]

Brilliant video 📹 Thank you PK

[@rajap6617]

Excellent video sir, please provide multiple videos with different formulas

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Our pleasure!

[@usmaniqbal1836]

Perfect 👍

[@AAlMamun_777]

Likely exception learning

[@PKAnExcelExpert]

Thanks

[@pandharinathjoshi6565]

Nice sir👌

[@trader.fx1]

Hello, Mr P.K. Thanks for your great tutorials, is it possible to save the excel file with a special image that doesn't look like excel?

[@akalarun]

If the 1st quarter is from April to June, how to arrive the same in the above formula

[@humanityIsAlwaysUltimate]

Hello sir, what is the usage of special characters in Excel formulas, especially in ctrl+1. Awaiting for your most valuable response 🎉

[@muhmmedalhmed2559]

Greetings to you ♥️🌹🌹 I wish you great success ♥️🌹 I have a question, I have Excel 2016 Windows 8 and function filter I did not find it I cannot download Office 2021. I do not know what is happening. I hope... Please give me a satisfactory answer. Greetings to you ♥️🌹🌹

[@trader.fx1]

Hi, I have an excel file and I created dashboard charts with a pivot table. When I delete the previous data, the settings I made, such as setting the value field or the number format, are disabled. Is there a way to fix this so the settings don't get deleted every time the data is wiped? Thanks