Dynamic include/don't include days formula

[mst3kr]

Trying to come up with a solution for a dynamic formula that I think I'm overthinking an answer to. Here's my issue:

I have daily forecasting that I need to capture for specific days, based on today's date, that will cover today & the next 2 days, except for over the weekend where I need to capture 5 days.

For example, If today was Monday, I would capture the data for Monday, Tuesday, & Wednesday. On Tuesdays, I would capture, Tu, We, & Th. On Wed, it would be We, Th, & Fr. On Thur, it would be Th, Fr, Sa, Su, & Mo. On Fri, it would be Fr, Sa, Su, Mo, & Tu. So, three day's worth of data if today is a Mon, Tue, or Wed, and then 5 days if it's Thu or Fri.

The challenge I have is trying to make this a dymanic process. I've attached what I'm wanting the 3-column, 5 row data to ultimately look like.

I've tried coming up with all sorts of crazy singular formulas in the Include? column, helper cells, and other tricks but haven't come up with something that works.

I know I'm overthinking it and wanted to see if anyone had any ideas...

Thanks!
-Greg

 

[awoohaw]

workday.intl function will work for you I think:

Mr Excel Questions 3.xlsm
	B	C	D	E
4	02/27/2023	Mon	Tuesday Feb 28, 2023	Wednesday Mar 01, 2023
5	02/28/2023	Tue	Wednesday Mar 01, 2023	Thursday Mar 02, 2023
6	03/01/2023	Wed	Thursday Mar 02, 2023	Friday Mar 03, 2023
7	03/02/2023	Thu	Friday Mar 03, 2023	Monday Mar 06, 2023
8	03/03/2023	Fri	Monday Mar 06, 2023	Tuesday Mar 07, 2023
9	03/06/2023	Mon	Tuesday Mar 07, 2023	Wednesday Mar 08, 2023
10	03/07/2023	Tue	Wednesday Mar 08, 2023	Thursday Mar 09, 2023
NetWorkDays

Cell Formulas
Range	Formula
C4:C10	C4	=CHOOSE(WEEKDAY(B4,1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
D4:D10	D4	=WORKDAY.INTL(B4,1,1)
E4:E10	E4	=WORKDAY.INTL(B4,2,1)

you can add holidays as well.

 

[mst3kr]

Thank you, awoohaw! This definitely gets me in the direction I was needing!