Get Data From Dates with Single Excel Function or Power Query

[@Officeinstructor]

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

[@michaeloloishuro6915]

Wonderful Nabil, The best has always been experienced!!

[@johnborg5419]

Thanks, usually I use the ceiling function to get the yearly quarter, but Month(Month( is a fantastic workaround. Thanks Nabil!! :) :)

[@timhinata6950]

Extracting quarter data from dates will help me so much with financial reports.

[@Luciano_mp]

Both methods are good, but I prefer power query. Your tutorials are brilliant. Thank you very much Nabil!

[@IvanCortinas_ES]

I prefer the single function method because you don't have to worry about updating the data. Thank you my friend!!!

[@Officeinstructor]

Yes I agree

[@SergioSantos-gk2ql]

week number revelation was mind-blowing

[@izzatkiswani]

Month of month is fantastic Thanks Nabil

[@dkeymoreno6517]

LET function was a game-changer.

[@rafaelmoraguzman2490]

That tip about discounts on Fridays using day names will change our reporting game-thanks!

[@54josuediaz]

The BYROW and HSTACK functions are real time-savers - thanks for sharing their potential!

[@GaelNoh]

-Watching this before starting my next project involving budgeting quarters-perfect timing!

[@JaelMurillo-z8q]

This tutorial simplifies complex date-related tasks in Excel beautifully.

[@Softwaretrain]

Thanks for the thorough explanation, as per usual. I just wanted to note that at 04:15, using the BYROW function wasn't necessary. You can utilize WEEKNUM to handle arrays by either adding a plus sign or a double negative before the range, like so: WEEKNUM(+A3:A23,2) or WEEKNUM(--A3:A23,2). This approach applies similarly to other functions like EOMONTH and WORKDAY. Also for the power query solution, we could use the below M code to get all columns in one step as a custom column and then expand it: =[ DD=Date.Day([Date]), DDD=Text.Start(Date.DayOfWeekName([Date]),3), DDDD=Date.DayOfWeekName([Date]), MM=Date.Month([Date]), MMM=Text.Start(Date.MonthName([Date]),3), MMMM=Date.MonthName([Date]), QTR="Qtr "&Text.From(Date.QuarterOfYear([Date])), WK YEAR="Wk "&Text.From(Date.WeekOfYear([Date])) ]

[@Officeinstructor]

Thanks for sharing

[@iansantiagomoraramirez9215]

-Great blend of teaching both basic and advanced techniques without overwhelming viewers.

[@enriquecaso]

The use of TEXT and BYROW functions was very insightful.

[@maviaelalvarez6193]

Office Instructor never disappoints with their tutorials.

[@juancarloshernandezestrada7185]

finally, a clear guide on dates

[@nadermounir8228]

Great tutorial Nabil, a very enjoyable video :) I am interested in taking the one day power Query course that u r providing in July

[@PalomaCamacho-id4qt]

Celebrating employee birthdays by month 🎉

[@michaeldingee743]

Great video. Question, how would you add the Header row to the final output.

[@johndurran614]

Excellent

[@brianxyz]

There's a much easier way to add prefixes in Power Query. Transform > Format > Add Prefix

[@galileadelarosa]

Celebrating birthdays with Excel's help now

[@zhuzhu9599]

Sir, is there any of your full course on Udemy?

[@mariaelenafigueroa3127]

Extracting data from dates has never been easier with these functions.

[@orlandomoreno8538]

Fridays discounts? Excel knows how to find them.