# Formula to list unique dates from a column?

#### JumboCactuar

##### Well-known Member
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

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
What is the exact range in B?

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

Last edited:
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.

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

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

Replies
3
Views
374
Replies
0
Views
520
Replies
3
Views
305
Replies
7
Views
998
Replies
1
Views
298

1,196,253
Messages
6,014,268
Members
441,810
Latest member
LouLou1234

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back