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
Is there a way to count the number of days to a targeted end date, then have the formula stop counting after an actual implemented date is entered in a separate column?
@@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!
I have a challenge. Instead of the dates I want the old value to subtract from the new value based on the value in another cell how can I contact you with maybe a screenshot
Thanks, but unfortunately this did not answer the question which it said it was going to cover in terms of calculating the total number of hours in excess of 24 hours, which is what I wanted to know.
Thank you so much! My formula is now correct. I needed to count the first day and with -1 it now works!
Awesome! Thanks for watching!
YOU ARE AMAZING!!
Thank you for watching!!
Great content! Thank you!
Glad to help! Thanks for watching!
Thank you for the techniques....
Glad to help! Thanks so much for watching and for subscribing to my Channel!
Good Teaching....
Thank you! Glad you found it helpful!
This was an excellent video!
Thanks so much, Frances! I'm glad you liked it. Thanks for watching!
Good job, thanks a lot.
Thanks so much for watching! Glad you found it helpful!
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?
Thank you., I am working for middle East project . I need to exclude Friday and Saturday as weekends. Can you help me with the formula
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
Is there a way to count the number of days to a targeted end date, then have the formula stop counting after an actual implemented date is entered in a separate column?
Hey Miss...network days who programmed this?
Hi there, NETWORKDAYS is a delivered function in Microsoft Excel using M365 version. Hope you found it helpful! Thanks for watching!
@@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.
Hi madam, in WORKDAY function how to set Only friday as weekend. Excel default take sunday, saturday as week off.. But i need to exclude only Fridays
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!
I have a challenge. Instead of the dates I want the old value to subtract from the new value based on the value in another cell how can I contact you with maybe a screenshot
Nice
Thank you! Thanks for watching!
=IF(D4
I tested with this formula and it is working:
=IF(A2
Thanks, but unfortunately this did not answer the question which it said it was going to cover in terms of calculating the total number of hours in excess of 24 hours, which is what I wanted to know.