DATE Range = Each Date in the range.

[AudyAnalyst]

Hello,

Is there a formula for extracting all Dates in a given range?

Employee	Start Date	End Date	Dates in between?
AA4587	03/27/2022	03/29/2022	(03/28/2022)
AA6987	05/01/2022	05/20/2022	05/02, 05/03,05/04,etc....

Any help would be GREATLY appreciated!!!

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1	Employee	Start Date	End Date	Dates in between?
2	AA4587	27/03/2022	29/03/2022	28/03/22
3	AA6987	01/05/2022	20/05/2022	02/05/22, 03/05/22, 04/05/22, 05/05/22, 06/05/22, 07/05/22, 08/05/22, 09/05/22, 10/05/22, 11/05/22, 12/05/22, 13/05/22, 14/05/22, 15/05/22, 16/05/22, 17/05/22, 18/05/22, 19/05/22
Main

Cell Formulas
Range	Formula
D2:D3	D2	=TEXTJOIN(", ",,TEXT(SEQUENCE(,C2-B2-1,B2+1),"dd/mm/yy"))

 

[AudyAnalyst]

How about

Fluff.xlsm
	A	B	C	D
1	Employee	Start Date	End Date	Dates in between?
2	AA4587	27/03/2022	29/03/2022	28/03/22
3	AA6987	01/05/2022	20/05/2022	02/05/22, 03/05/22, 04/05/22, 05/05/22, 06/05/22, 07/05/22, 08/05/22, 09/05/22, 10/05/22, 11/05/22, 12/05/22, 13/05/22, 14/05/22, 15/05/22, 16/05/22, 17/05/22, 18/05/22, 19/05/22
Main

Cell Formulas
Range	Formula
D2:D3	D2	=TEXTJOIN(", ",,TEXT(SEQUENCE(,C2-B2-1,B2+1),"dd/mm/yy"))

Thank you for your quick response.
When I tried it I received an Error, "#CALC!", for the one day between, not too critical, but for learning, do you have any advice to improve the formula?

Book5
	A	B	C	D	E
1	Person Code	Start Date	End Date	Total Working Time Taken (Time Units)	Formula Test
2	AA548	Wednesday, July 21, 2021	Friday, July 23, 2021	24	2021-07-22
3	AA549	Monday, June 20, 2022	Friday, June 24, 2022	40	2022-06-21, 2022-06-22, 2022-06-23
4	AA550	Monday, October 18, 2021	Tuesday, October 19, 2021	16	#CALC!
5	AA551	Monday, May 30, 2022	Wednesday, June 1, 2022	24	2022-05-31
6	AA552	Monday, June 13, 2022	Wednesday, June 22, 2022	64	2022-06-14, 2022-06-15, 2022-06-16, 2022-06-17, 2022-06-18, 2022-06-19, 2022-06-20, 2022-06-21
7	AA553	Wednesday, June 8, 2022	Monday, June 13, 2022	32	2022-06-09, 2022-06-10, 2022-06-11, 2022-06-12
8	AA554	Monday, May 16, 2022	Friday, May 27, 2022	80	2022-05-17, 2022-05-18, 2022-05-19, 2022-05-20, 2022-05-21, 2022-05-22, 2022-05-23, 2022-05-24, 2022-05-25, 2022-05-26
9	AA555	Monday, May 30, 2022	Wednesday, June 1, 2022	24	2022-05-31
10	AA556	Thursday, June 23, 2022	Tuesday, June 28, 2022	32	2022-06-24, 2022-06-25, 2022-06-26, 2022-06-27
11	AA557	Monday, June 13, 2022	Friday, June 24, 2022	80	2022-06-14, 2022-06-15, 2022-06-16, 2022-06-17, 2022-06-18, 2022-06-19, 2022-06-20, 2022-06-21, 2022-06-22, 2022-06-23
12	AA558	Tuesday, May 3, 2022	Friday, May 20, 2022	112	2022-05-04, 2022-05-05, 2022-05-06, 2022-05-07, 2022-05-08, 2022-05-09, 2022-05-10, 2022-05-11, 2022-05-12, 2022-05-13, 2022-05-14, 2022-05-15, 2022-05-16, 2022-05-17, 2022-05-18, 2022-05-19
Sheet1

Cell Formulas
Range	Formula
E2:E12	E2	=TEXTJOIN(", ",,TEXT(SEQUENCE(,C2-B2-1,B2+1),"YYYY-MM-DD"))

 

[Fluff]

What do you want to return if there are no days between the dates?

 

[AudyAnalyst]

What do you want to return if there are no days between the dates?

I'm sorry!!!! I didn't even remotely ask the question correctly, (It has been a week). I'm concerned about Saturdays and Sundays, in Row 10 I want the formula to only return Traditional Week Days (Mon-Fri). Is that Possible?

 

[Fluff]

Ok, but what should happen if there are none?

 

[AudyAnalyst]

Ok, but what should happen if there are none?

If there is no dates in between, "0" should be fine.

 

[Fluff]

Ok, how about

=LET(d,NETWORKDAYS(B2,C2)-2,IF(d=0,"0",TEXTJOIN(", ",,TEXT(WORKDAY(B2,SEQUENCE(,d)),"YYYY-MM-DD"))))

 

[AudyAnalyst]

Solved.
Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.