Excel WORKDAY Function Trick to List Dates that Most People Don't Know

No video

Excel WORKDAY Function Trick to List Dates that Most People Don't Know

Рет қаралды 19,545

MyOnlineTrainingHub

Күн бұрын

Пікірлер: 48

@nadermounir8228 2 жыл бұрын

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)

@MyOnlineTrainingHub 2 жыл бұрын

Glad it was helpful!

@IvanCortinas_ES 2 жыл бұрын

That's great the last trick! Thank you Mynda!

@MyOnlineTrainingHub 2 жыл бұрын

Pleased to hear you liked that one, Ivan!

@vijayarjunwadkar 2 жыл бұрын

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! 😊👍

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear, Vijay!

@harnishsingh5707 2 жыл бұрын

Hello mynda. I want to learn excel can you please teach me online.

@MyOnlineTrainingHub 2 жыл бұрын

Sure, Harnish. You can find my courses here: www.myonlinetraininghub.com/

@Excelambda 2 жыл бұрын

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

@MyOnlineTrainingHub 2 жыл бұрын

Not for the feint hearted!

@JoseAntonioMorato 2 жыл бұрын

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)) 🤗

@Excelambda 2 жыл бұрын

@@JoseAntonioMoratoProbably because if I have a lambda I can use it on other several occasions, and W(...) is few chars shorter.✌😉

@JoseAntonioMorato 2 жыл бұрын

@@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. 👍🤗

@Excelambda 2 жыл бұрын

@@JoseAntonioMorato Glad you like it!!✌🙏

@Elbranto1 2 жыл бұрын

Great video as always, thank you

@MyOnlineTrainingHub 2 жыл бұрын

Our pleasure, Fred!

@lchase7858 2 жыл бұрын

Another "great" video. Thank you

@MyOnlineTrainingHub 2 жыл бұрын

Glad you enjoyed it, Larry!

@darrylmorgan 2 жыл бұрын

Hi Mynda!Really Great Tutorial,Super Cool Trick...Thank You :)

@MyOnlineTrainingHub 2 жыл бұрын

Thanks so much, Darryl!

@wayneedmondson1065 2 жыл бұрын

Awesome Mynda! Thanks!!

@MyOnlineTrainingHub 2 жыл бұрын

Thanks so much, Wayne!

@chrism9037 2 жыл бұрын

Excellent thanks Mynda!

@MyOnlineTrainingHub 2 жыл бұрын

Cheers, Chris 😊

@SD-ko4jd 2 жыл бұрын

Thanks a lot :)

@MyOnlineTrainingHub 2 жыл бұрын

You're welcome!

@jovenciojimenez5500 2 жыл бұрын

Thanks.for sharing!

@MyOnlineTrainingHub 2 жыл бұрын

My pleasure!

@davidlinton4127 2 жыл бұрын

Great stuff, thanks!!!

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it, David!

@einoconsult5563 2 жыл бұрын

Thanks Mynda ! Could you update your Excel Date and Time Workbook to include the thing you present in the video please ?

@MyOnlineTrainingHub 2 жыл бұрын

I already have. It's on in the WORKDAY.INTL section.

@einoconsult5563 2 жыл бұрын

@@MyOnlineTrainingHub Thanks, for some reasons I did not see it the first time

@MrGulsaeed 2 жыл бұрын

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

@MyOnlineTrainingHub 2 жыл бұрын

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

@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

@catherine7962 2 жыл бұрын

Hi. I need to ctreate a sepreadsheet with 5 rows per workday. Any ideas how to do that?

@MyOnlineTrainingHub 2 жыл бұрын

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

@arbazahmad7177 2 жыл бұрын

Great 👍

@MyOnlineTrainingHub 2 жыл бұрын

Thank you 👍

@teoxengineer 2 жыл бұрын

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...?

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it, Emre! I haven't tried it with other functions, but good idea.