Summarizing many dates into one

[Guzzlr]

Hello all.
I'm having a little trouble finding a built in excel formula for what I have in mind.
Lets say:
(B4:B12) has the same date of 2-1-2022
(B13: B16) has the same date of 2-2-2022
(B17:B42) has the same date of 2-3-2022
and so on all the way down to the current date, and variation in the number of days.

What I'm trying to do is in (D4:to end of Column B) summarize the dates.
D4 = 2-1-2022
D5 = 2-2-2022
D6 = 2-3-2022

The summary of dates, in column D, would go as far as the last date entered in column B.
For example, if the last date in column B ended with 2-17-2022, row 282, then the last entry in Column D would also end at 2-17-2022, only not in row 282. Basically in row 20 (I think) if B4 was 2-1-2022.
I would like to not use a pivot table.

Not sure if that makes sense.
Thanks for the help

 

[bebo021999]

Book1
	B	C
4	01-Feb	01-Feb
5	01-Feb	02-Feb
6	02-Feb	03-Feb
7	02-Feb
8	02-Feb
9	03-Feb
10	03-Feb
11	03-Feb
Sheet2

Cell Formulas
Range	Formula
B10:B11,B7:B8	B7	=B6
C4:C11	C4	=IFERROR(INDEX(INDIRECT("$B$4:$B"&COUNTA($B$4:$B$1000)+3),MATCH(0,INDEX(COUNTIF($C$3:C3,INDIRECT("$B$4:$B"&COUNTA($B$4:$B$1000)+3)),),0)),"")

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Guzzlr]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Hello...
This machine has Microsoft 365 Apps for Enterprise.

 

[Oaktree]

D4 = UNIQUE(B4:B282)

Then, format column D as date

 

[Fluff]

Thanks for that, how about

+Fluff 1.xlsm
	A	B	C	D
1
2		01/02/2022		01/02/2022
3		01/02/2022		02/02/2022
4		01/02/2022		03/02/2022
5		01/02/2022		04/02/2022
6		01/02/2022		05/02/2022
7		02/02/2022
8		02/02/2022
9		02/02/2022
10		02/02/2022
11		02/02/2022
12		02/02/2022
13		03/02/2022
14		03/02/2022
15		03/02/2022
16		04/02/2022
17		04/02/2022
18		04/02/2022
19		04/02/2022
20		05/02/2022
21
Main

Cell Formulas
Range	Formula
D2:D6	D2	=UNIQUE(FILTER(B2:B100,B2:B100<>""))
Dynamic array formulas.

 

[Guzzlr]

Thanks for that, how about

+Fluff 1.xlsm
	A	B	C	D
1
2		01/02/2022		01/02/2022
3		01/02/2022		02/02/2022
4		01/02/2022		03/02/2022
5		01/02/2022		04/02/2022
6		01/02/2022		05/02/2022
7		02/02/2022
8		02/02/2022
9		02/02/2022
10		02/02/2022
11		02/02/2022
12		02/02/2022
13		03/02/2022
14		03/02/2022
15		03/02/2022
16		04/02/2022
17		04/02/2022
18		04/02/2022
19		04/02/2022
20		05/02/2022
21
Main

Cell Formulas
Range	Formula
D2:D6	D2	=UNIQUE(FILTER(B2:B100,B2:B100<>""))
Dynamic array formulas.

This is working nicely.
Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.