Formula to Calculate a due date with excluding dates

[Sarina28]

Hello,

I'm trying to build a tool to support teachers with due dates.
It is possible to make a formula that would exclude summer.
So if the target date is 9/21/24, I would like the formula to produce a date 60 days before excluding June 5, 2024 to August 19, 2024.
I have found information about excluding weekends and holidays but could not find information about a specific date range.

Thank you for your assistance.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=WORKDAY(A2,-60,SEQUENCE(76,,DATE(2024,6,5)))

 

[Sarina28]

Thank you so much for your help.
Unfortunately, that did not work the output was 45398

Also, I do not want to exclude weekends or holidays- just the summer- June 5, 2024 to August 19, 2024

 

[Fluff]

Unfortunately, that did not work the output was 45398

You need to format the cell as a date.
If you want to include weekends then use

=WORKDAY.INTL(A2,-60,"0000000",SEQUENCE(76,,DATE(2024,6,5)))

 

[Sarina28]

Oh my goodness, I am an idiot. I am so sorry.
This totally worked, thank you, thank you, thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.