Thank you so much for the clear videos. One small discrepancy, possibly due to things changing since 2015 when you made this video (I'm writing in 2022, using Calc version 7). It seems to me that I have to use a 2 instead of a 1 within the workday.intl function. You show that 1 signifies Sat/Sun, but when I use a 1 it seems that it is interpreting that as Fri/Sat. Just curious if you know anything about this. Thanks again!
to be clearer, this is the function that's working for me, to replicate what you're doing in the video starting at 8:30: =IF(ISNUMBER(D14),WORKDAY.INTL(C14,D14,2,A$44:A$56)-1,"")
when you said you were going to invent some holidays, I thought you meant something like "Eating Waffles and Volunteering Day" or something! But regardless, the video is very helpful:)
[Please share your Vast knowledge of Libre.] How to UPLOAD, a LibreCalc, file? I clk 'ppr clip...selct Brouse...selct file in DOCMNTS folder... NOTHING HAPPENS ??
![Libre Office Calc - Array Formulas and Functions - Part 1 - [ Libre Calc Office Advanced Tutorial ]](http://i.ytimg.com/vi/66dz_nomJoA/mqdefault.jpg)
Diction very clear + NO MUSIC - Fantastic !
Merci beaucoup monsieur.
to create Gantt in LO for holidays planning is a good task for all your holidays. why it is so hard?
Very clear! Thank you so much!
My Vision is Augmented.
sir i dont know where I'm wrong, i follow every step your instruct, when i insert the formula exacly the same collumn and row the result err504
Good video, Thanks for uploading
Thank you so much for the clear videos. One small discrepancy, possibly due to things changing since 2015 when you made this video (I'm writing in 2022, using Calc version 7). It seems to me that I have to use a 2 instead of a 1 within the workday.intl function. You show that 1 signifies Sat/Sun, but when I use a 1 it seems that it is interpreting that as Fri/Sat. Just curious if you know anything about this. Thanks again!
to be clearer, this is the function that's working for me, to replicate what you're doing in the video starting at 8:30: =IF(ISNUMBER(D14),WORKDAY.INTL(C14,D14,2,A$44:A$56)-1,"")
of course, note that my actual cell ID's are different from the videos because of my particular project
when you said you were going to invent some holidays, I thought you meant something like "Eating Waffles and Volunteering Day" or something! But regardless, the video is very helpful:)
lol
NICE VOICE!!!
[Please share your Vast knowledge of Libre.] How to UPLOAD, a LibreCalc, file? I clk 'ppr clip...selct Brouse...selct file in DOCMNTS folder... NOTHING HAPPENS ??
Thank you very much :)