End date from a given start date rolled forward by specific number of working days

Try

=WORKDAY.INTL(A1,23)

You can include HOLIDAYS in this function

So, 31 May 2022 plus 23 "working days" (working days being Mon-Fr, 5 day week). That rolled forward end date would be 1 June 2022 (assuming no bank holidays).

That's nonsense!

01/06/2022 is the day after 31/05/2022.

So, try again: what date are you really expecting?

As per Ali's reply: 23 working days is 1st JULY .. which co-incidentally is a FRIDAY !!!!!

If you want to exclude Bank Holidays from the calculation, you need to list them somewhere:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D	E	F	G	H
2	Start:		Plus 23 working days:				Bank Holidays:
3	31/05/2022		05/07/2022				02/06/2022	Platinum Jubilee
4							03/06/2022	Platinum Jubilee

Sheet: Sheet1

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	C
3	=WORKDAY.INTL(A3,23,1,$G$3:$G$4)

Sheet: Sheet1

Glad to have helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.