Excel function = WORKDAY

[Sushiboy]

HI all

Using workday function to give me T-1 days. So for example if its Thursday, it will return Wednesday based on the function = Workday(Date, -1)

Now Im trying to make this work so it excludes every friday. For example, if on Monday, i want it to return Thursday (not friday)

Any help is much appreciated

Regards
Martin

 

[Dave Patton]

Excel 2010
	A	B
1	Date
2	Mon 21-Jan-19	Thu 17-Jan-19
3
1c

Cell Formulas
Range	Formula
B2	=WORKDAY.INTL(A2,-1,"0000111")

 

[Fluff]

How about
=IF(WEEKDAY(A1,2)=1,WORKDAY(A1,-2),WORKDAY(A1,-1))

 

[Sushiboy]

Many thanks for the reply.
Out of interest what does 0000111 represent?

 

[MARK858]

From Office.com....

Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday. 1 represents a non-workday and 0 represents a workday. Only the characters 1 and 0 are permitted in the string. 1111111 is an invalid string.

For example, 0000011 would result in a weekend that is Saturday and Sunday.

https://support.office.com/en-us/article/workday-intl-function-a378391c-9ba7-4678-8a39-39611a9bf81d

https://exceljet.net/excel-functions/excel-workday.intl-function