WORKDAY.INTL Formula not working

[falcios]

Someone provided me the formula below and it worked great at one point and now it's not working

I only want dates for Tuesday, Wednesday, Friday, and Saturday

I entered 11/2/21 on A1 which is a Tuesday
I was told to enter the formula on A2
It returns the date as a Saturday, when it should be Wednesday 11/3/21.

Any idea what is happening or what am I doing wrong?

Thanks in advance.

=WORKDAY.INTL($A$1+7-WEEKDAY($A$1,1)-1,ROWS(A$2:A2),"1001001")

 

[Alex Blakenburg]

Not a 100% on what you are trying to achieve but what happens if you just use this

=WORKDAY.INTL($A$1,ROWS(A$2:A2),"1001001")

 

[falcios]

Thanks so much, that worked. You're a guru.

What is the difference between these formulas?

 

[Dave Patton]

Asssumptions:
- workdays Tuesday, Wednesday, Friday and Saturday
- you require 5 days

Review Excel's help for the function.

Networkdays.xlsm
	A	B	C
1	Tue 02-Nov-21	5	Wed 10-Nov-21
2
1d

Cell Formulas
Range	Formula
C1	C1	=WORKDAY.INTL(A1,B1,"1001001")

 

[Alex Blakenburg]

Thanks so much, that worked. You're a guru.

What is the difference between these formulas?

I can only assume that the formula was used for a slightly different requirement.

It looks like the starting date was not always the 1st row of the date range and perhaps somewhere else on the spreadsheet.
(Hence the hard coding of $A1$)
And that there was a requirement for the 1st date in the date range to be Saturday.
Is Saturday perhaps the official start date of the week ?
The extra part in the formula (+7-WEEKDAY($A$1,1)-1) only affects the first entry in the date range and forces to always to be Saturday, after that it just adds 1 workday for each additional row.