Formula to list unique dates from a column?

[JumboCactuar]

I have some data and in column B is a mixup of dates from the current week (total of 6 unique values)

How can i output the dates for Monday to Saturday from the column of dates?

Thanks

 

[Aladin Akyurek]

What is the exact range in B?

 

[JumboCactuar]

No specific range as it varies by week, but its always below 10000 (starting at B2)

 

[Tetra201]

I have some data and in column B is a mixup of dates from the current week (total of 6 unique values)

How can i output the dates for Monday to Saturday from the column of dates?

If it's always 6 unique values for a single particular week, then:
Monday's date would be =MIN(B:B)
Tuesday's date would be =MIN(B:B)+1
and so on.

 

[JumboCactuar]

If it's always 6 unique values for a single particular week, then:
Monday's date would be =MIN(B:B)
Tuesday's date would be =MIN(B:B)+1
and so on.

thanks for the reply but i figured this would be a lot of hard work to pull data for each day.

Instead i made a helper column "=text(B2,"DDDD") and then use with a pivot table

 

[Tetra201]

Glad to hear you've found a solution that works for you.