=networkdays.intl

Hi Guys,

Can anyone help me to change this so that the week starts on a Wednesday and runs through to a Tuesday?

=NETWORKDAYS.INTL(DATE(YEAR(W52)-(NETWORKDAYS.INTL(DATE(YEAR(W52),4,18),W52,"0111111")<1),4,18),W52,"0111111")

Thanks

Rather than sharing a non-working formula, consider uploading a small representative sample of your data along with the desired result (manually entered) based off of that data.

We can then use that to create a working formula for you.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

Also, if a week starts on a Wednesday and ends on a Tuesday, does that mean that there are no "weekends"?

If that is the case, why are you using the NETWORKDAYS.INTL function?

If that is not the case, what days are the "weekend" and shouldn't be counted?

Originally Posted by 63falcondude

Also, if a week starts on a Wednesday and ends on a Tuesday, does that mean that there are no "weekends"?

If that is the case, why are you using the NETWORKDAYS.INTL function?

If that is not the case, what days are the "weekend" and shouldn't be counted?

Wednesday - Tuesday is a full week

Originally Posted by Excelski

Wednesday - Tuesday is a full week

My point exactly. This would mean that there are no weekends.

If there are no weekends, I do not see why the O.P. wants to use the NETWORKDAYS.INTL function (as said in post #3).

Originally Posted by 63falcondude

My point exactly. This would mean that there are no weekends.

If there are no weekends, I do not see why the O.P. wants to use the NETWORKDAYS.INTL function (as said in post #3).

I am not sure I get your point....... but Ill leave it the the O.P. to respond