Create a list of working days - Excel WORKDAY function

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 ก.ย. 2024

ความคิดเห็น • 13

  • @luukluther8605
    @luukluther8605 2 ปีที่แล้ว +1

    Very helpful. Thank you!

  • @AleksPTA
    @AleksPTA 2 ปีที่แล้ว +1

    Great video summary, thank you.

    • @ExcelatWork
      @ExcelatWork  2 ปีที่แล้ว +1

      Thank you!! Glad you enjoyed it!

  • @stevenintexas6947
    @stevenintexas6947 ปีที่แล้ว

    Thank you. You are an excellent teacher and I love your accent. Is there a function to get a list of all Holidays for a whole year?

  • @kyfparacha
    @kyfparacha ปีที่แล้ว +1

    Hi. Great video, just what I was looking for. The only problem I am having is @ 1.44 after I hight the cells my Autofill option does not show like yours. How can I fix this in my Excel 365? Thank you and regards

    • @ExcelatWork
      @ExcelatWork  ปีที่แล้ว

      Hi Muhammad! Please try the following: File tab > Options > Advanced > Under Cut, Copy and Paste, enable Show Paste Button Options when content is pasted. I hope this works for you. Best regards, Sharyn

  • @daniel.shalome
    @daniel.shalome 2 ปีที่แล้ว +1

    i want only sat and Sunday repeated
    what can I do

    • @ExcelatWork
      @ExcelatWork  2 ปีที่แล้ว

      Hi Daniel. I think what you need is the WORKDAY.INTL function. Here's a link to an excellent tutorial. Hope it helps exceljet.net/formula/series-of-dates-by-weekends

  • @jimysixa3071
    @jimysixa3071 ปีที่แล้ว +1

    or my question is how to exclude the working day,some of them

    • @ExcelatWork
      @ExcelatWork  ปีที่แล้ว

      Hi Jimy. You may find the solution you need here exceljet.net/formulas/add-days-exclude-certain-days-of-week I hope it helps.

  • @BaKer312213
    @BaKer312213 หลายเดือนก่อน +1

    thank fuck for this

    • @ExcelatWork
      @ExcelatWork  17 วันที่ผ่านมา

      😂🤣 So happy it helped!