Need help to determine a date

[Emma_Foyle]

I am currently working on a calculator that adds an entitlement by days to a date to determine an end date.
For example if date is 19/09/2023 and the entitlement in days is 79 days but this person only works specific days in a week (Monday, Wednesday and Thursday).
I want to be able to work out when the entitlement would run out.
I have done this for someone who works Monday to Friday using the workday formula but cannot work out how I do this based on specified days of week?

 

[awoohaw]

try WORKDAY.INTL
The zeros represent the days to count/work. You can also add holiday lists as an optional 4th argument.

Book2
	A	B
1
2	Tue 2023-09-19	Wed 2024-03-20
Sheet3

Cell Formulas
Range	Formula
B2	B2	=WORKDAY.INTL($A2,79,"0100111")

 

[Emma_Foyle]

try WORKDAY.INTL
The zeros represent the days to count/work. You can also add holiday lists as an optional 4th argument.

Book2
	A	B
1
2	Tue 2023-09-19	Wed 2024-03-20
Sheet3

Cell Formulas
Range	Formula
B2	B2	=WORKDAY.INTL($A2,79,"0100111")

Thank you, this worked!

 

[awoohaw]

My pleasure. Happy to help. Best Wishes.
And welcome to the Mr. Excel forum!