Thank you so much! My formula is now correct. I needed to count the first day and with -1 it now works!
@SharonSmith
8 ай бұрын
Awesome! Thanks for watching!
@j.r.61
Жыл бұрын
YOU ARE AMAZING!!
@SharonSmith
Жыл бұрын
Thank you for watching!!
@silvestrecamposano6317
Жыл бұрын
Thank you for the techniques....
@SharonSmith
Жыл бұрын
Glad to help! Thanks so much for watching and for subscribing to my Channel!
@oleandra3759
8 ай бұрын
Great content! Thank you!
@SharonSmith
8 ай бұрын
Glad to help! Thanks for watching!
@francesdobbins2964
Жыл бұрын
This was an excellent video!
@SharonSmith
Жыл бұрын
Thanks so much, Frances! I'm glad you liked it. Thanks for watching!
@hassanrozh6579
Жыл бұрын
Good job, thanks a lot.
@SharonSmith
Жыл бұрын
Thanks so much for watching! Glad you found it helpful!
@suzannesayabuaovong5145
Жыл бұрын
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.
@ladydemando
11 ай бұрын
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?
@mohanr8607
Жыл бұрын
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
@SharonSmith
Жыл бұрын
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!
@mohanr8607
Жыл бұрын
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
@syedikramullah1114
Жыл бұрын
Nice
@SharonSmith
Жыл бұрын
Thank you! Thanks for watching!
@Hey_Delight
Жыл бұрын
Hey Miss...network days who programmed this?
@SharonSmith
Жыл бұрын
Hi there, NETWORKDAYS is a delivered function in Microsoft Excel using M365 version. Hope you found it helpful! Thanks for watching!
@Hey_Delight
Жыл бұрын
@@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.
@SathishKumar-po7ev
Жыл бұрын
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
@SharonSmith
Жыл бұрын
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!
@azstudio9489
Жыл бұрын
=IF(D4
@SharonSmith
Жыл бұрын
I tested with this formula and it is working: =IF(A2
Пікірлер: 26