• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Last 7 weekdays from a particular date

M

Mr.Karr

Member
Hello experts,

I'm trying to list out last 7 working days/weekdays from a particular date. The idea is to connect slicer selection value to a cell and derive out last 7 weekdays for further analysis and pull values.

Please refer to the sample file attached.

Thanks,
Kar
 

Attachments

  • sample file weekdays.xlsx
    9.9 KB · Views: 6
Kar

C8: =WORKDAY.INTL(D3,-1,1)
C9: =WORKDAY.INTL(C8,-1,1)

Copy C9 Down

upload_2016-10-27_15-13-23.png

If you have a list of holidays you can use them assuming they are in A2:A10

C8: =WORKDAY.INTL(D3,-1,1, A2:A10)
C9: =WORKDAY.INTL(C8,-1,1, A$2:A$10)
Copy C9 down
 
You must log in or register to reply here.
Back
Top