Get Data From Dates with Single Excel Function or Power Query
If you have a list with some dates, it might be important for analysis and reporting to extract information from these dates such as The Day the year or month for which we have corresponding functions. But sometimes you need much more information such as the day name if the store offers a discount on Fridays, or the month name if a company celebrates the birthday of employees born on each month, may be the quarter of the year for budgeting or even the week number.
In this tutorial I show you how to get all this information either with a single cell function or by using Power Query.
Let me know in a comment, which method you prefer.
===========================================================
Watch my tutorial where I show 5 methods for extracting Quarter from a Date:
• Calculate The Quarter of the year fro...
######################################################
The OfficeInstructor Training Centre offers Corporate Training in Computer Applications:
1-At Client Site (North America)
2- Remotely (Anywhere in the world)
3-In Our State of Art Classrooms (in Toronto Canada)
To check our course catalog or Book a Corporate Training visit:
www.OfficeInstructor.com