How to have column record earliest date and latest date

[Hoss2434]

Hello I was hoping if anyone can show how to create a separate column that displays the earliest column and latest column in a data field. Below is a before and after of what I am looking for:

Before:

Customer#	Transaction Date
Customer 1	12/15/2022
Customer 1	1/20/2022
Customer 1	3/10/2023
Customer 2	11/9/2022
Customer 2	2/12/2023
Customer 2	3/8/2023

After:

Customer#	Transaction Date	Earliest Date	Latest Date
Customer 1	12/15/2022	12/15/2022	3/10/2023
Customer 1	3/10/2023	12/15/2022	3/10/2023
Customer 1	1/20/2022	12/15/2022	3/10/2023
Customer 2	2/10/2023	11/9/2022	3/8/2023
Customer 2	11/9/2022	11/9/2022	3/8/2023
Customer 2	3/8/2023	11/9/2022	3/8/2023

So in this scenario, we have separate columns that displays the earliest, and the latest transaction made based n Customer#.

If anyone can help me create a formula for this that would be greatly appreciated!

Thanks

[BS_THE_ANALYST]

@Hoss2434 here's one way:

[BS_THE_ANALYST · Accepted solution]

@Hoss2434 
If you wanted to change the format back to how you wanted it: