Thanks Mynda for this great video 📹. It is great that you are showing us the new method (office 365) and the old school one (excel 2019 and before)
@MyOnlineTrainingHub2 жыл бұрын
Glad it was helpful!
@IvanCortinas_ES2 жыл бұрын
That's great the last trick! Thank you Mynda!
@MyOnlineTrainingHub2 жыл бұрын
Pleased to hear you liked that one, Ivan!
@Elbranto12 жыл бұрын
Great video as always, thank you
@MyOnlineTrainingHub2 жыл бұрын
Our pleasure, Fred!
@vijayarjunwadkar2 жыл бұрын
Thanks Mynda, this video was just-in-time for me, as I was working on some date calculations and you were magically there with the tutorial and the accompanying PDF! Super! 😊👍
@MyOnlineTrainingHub2 жыл бұрын
Great to hear, Vijay!
@harnishsingh57072 жыл бұрын
Hello mynda. I want to learn excel can you please teach me online.
@MyOnlineTrainingHub2 жыл бұрын
Sure, Harnish. You can find my courses here: www.myonlinetraininghub.com/
@chrism90372 жыл бұрын
Excellent thanks Mynda!
@MyOnlineTrainingHub2 жыл бұрын
Cheers, Chris 😊
@wayneedmondson10652 жыл бұрын
Awesome Mynda! Thanks!!
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much, Wayne!
@lchase78582 жыл бұрын
Another "great" video. Thank you
@MyOnlineTrainingHub2 жыл бұрын
Glad you enjoyed it, Larry!
@Excelambda2 жыл бұрын
Great video!! To avoid introducing wrong strings, a lambda W(w): =LAMBDA(w,TEXTJOIN("",,IFNA(XMATCH(SEQUENCE(7),w)^0,0))) =W({2,6,7}) will return 0100011
@MyOnlineTrainingHub2 жыл бұрын
Not for the feint hearted!
@JoseAntonioMorato2 жыл бұрын
If the value ({2;6;7}) must be entered manually, to obtain the result of LAMBDA, why not insert it directly into the formula? =TEXTJOIN("",,IFNA(XMATCH(SEQUENCE(7),{2,6,7})^0,0)) 🤗
@Excelambda2 жыл бұрын
@@JoseAntonioMoratoProbably because if I have a lambda I can use it on other several occasions, and W(...) is few chars shorter.✌😉
@JoseAntonioMorato2 жыл бұрын
@@Excelambda Dear Exceλambda , OK! But even giving the name «Weekend» to LAMBDA, it is difficult to know what the «W» means for those who do not know the system. Only for those who know what it means. However, I forgot to say that I really liked your idea. 👍🤗
@Excelambda2 жыл бұрын
@@JoseAntonioMorato Glad you like it!!✌🙏
@darrylmorgan2 жыл бұрын
Hi Mynda!Really Great Tutorial,Super Cool Trick...Thank You :)
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much, Darryl!
@jovenciojimenez55002 жыл бұрын
Thanks.for sharing!
@MyOnlineTrainingHub2 жыл бұрын
My pleasure!
@davidlinton41272 жыл бұрын
Great stuff, thanks!!!
@MyOnlineTrainingHub2 жыл бұрын
Glad you liked it, David!
@SD-ko4jd2 жыл бұрын
Thanks a lot :)
@MyOnlineTrainingHub2 жыл бұрын
You're welcome!
@einoconsult55632 жыл бұрын
Thanks Mynda ! Could you update your Excel Date and Time Workbook to include the thing you present in the video please ?
@MyOnlineTrainingHub2 жыл бұрын
I already have. It's on in the WORKDAY.INTL section.
@einoconsult55632 жыл бұрын
@@MyOnlineTrainingHub Thanks, for some reasons I did not see it the first time
@derellbrown3001 Жыл бұрын
what if you have to account for more than one holiday calendar? i.e. US and Canada?
@MyOnlineTrainingHub Жыл бұрын
Not sure what you mean. Perhaps you can post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@catherine79622 жыл бұрын
Hi. I need to ctreate a sepreadsheet with 5 rows per workday. Any ideas how to do that?
@MyOnlineTrainingHub2 жыл бұрын
Hi Catherine, I've been asked this question before. Please see this post (change the 3 to 5 for your needs): www.myonlinetraininghub.com/excel-forum/excel/how-do-i-easily-set-the-date-to-show-3-times-then-move-on-to-the-next-3#p11280
@MrGulsaeed2 жыл бұрын
Hi Mynda, Wht if i have list of days off and I want to calculate the difference? As the list get big its not fisiable to specify formula in each row. Thank in advance. 20-May-22 20-Jun-22 Mon, Tue 20-Mar-22 20-May-22 Wed, Thu 20-Jan-22 20-Apr-22 Sat, Sun 20-Nov-21 20-Mar-22 Mon, Tue, Wed 20-Sep-21 20-Feb-22 Fri, Sat, Sun 20-Jul-21 20-Jan-22 Sat, Sun, Mon 20-May-21 20-Dec-21 Tue, Wed, Thu
@MyOnlineTrainingHub2 жыл бұрын
Not sure what you mean by 'calculate the difference'. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@arbazahmad71772 жыл бұрын
Great 👍
@MyOnlineTrainingHub2 жыл бұрын
Thank you 👍
@teoxengineer2 жыл бұрын
Mynda, are you serious? how does it happen? I haven't seen before this type of formula "01100..." 🤯 very screet tip and it is so useful I think. Does it work in Aggregate and Subtotal functions because sub functions are being used same type of syntax like (...)1-Average , (...)2-Count etc...?
@MyOnlineTrainingHub2 жыл бұрын
Glad you liked it, Emre! I haven't tried it with other functions, but good idea.