Thank you!! Yes, you are amazing, and very much appreciated. Can you do a video on how to create a formula for calculating leave entitlements allotted, incorporating time used, and displaying entitlements remaining for PDL, fmla, pfl, and cfra? Just curious if this is possible. I’m currently doing this manually.
Say I want to do this, but take it a step farther? I am using this formula to figure how many days it takes us to to get a quote out to clients--so for example--a client sends us a quote request on Monday, and we get it to them Wednesday--we don't want to count Monday--just Tuesday and Wednesday--how do I do that?
Hello, yes, you would want to use: =NETWORKDAYS.INTL(start date, end date, 7, [holidays]) Using "7" for the Weekend argument in the NETWORKDAYS.INTL syntax will recognize Friday and Saturday as your weekend days. I hope this helps! Thanks for watching!
Great. Can you help me with, Which formula should I use If i need to include weekends and calculate SLA. Actually, I need to calculate SLA between two dates including weekends. Support hours are 8 AM to 10 PM
@@SharonSmith Don't have MS365...but love to try it someday. I'm a big fan of Excel....and still using 2007 but I love it and the limited functions there...challenging my creativity, math and logic in nesting various applicable functions to build efficient systems helping me with my freelance accounting work. Thank you for your response.
Hello! You can use =WORKDAY.INTL and then the syntax would be: =WORKDAY.INTL(startdate, days, [weekend], [holidays]) in the argument area for [weekend], but the number 16 - this represents Fridays only as your weekend. The same holds true for the NETWORKDAYS.INTL formula. Hope this helps! Thanks for watching!