List the date when the month is changed

[gtd526]

Hello,
Need to create a list of date values then the month is changed.
In this case it would only list 8/1.
I want to use several columns with the same date format to create the list. This might result in 2 month changes.
Columns will include B, I, P
Same # of rows.

Thank you

Smoking Habit.xlsm
	P
3	7/28
4	7/28
5	7/29
6	7/29
7	7/30
8	7/30
9	7/31
10	7/31
11	8/1
12	8/1
13	8/2
14	8/2
15	8/3
16	8/3
17	8/4
18	8/4
19	8/5
20	8/5
21	8/6
22	8/6
23	8/7
24	8/7
25	8/8
26	8/8
27	8/9
28	8/9
29	8/10
30	8/10
Count

 

[My Aswer Is This]

Please explain in more detail what your ultimate Goal is:

Do you want a vba script to enter all the Dates in current month into column one of sheet named Alpha. And clear all dates in this column 1 previously entered.

 

[gtd526]

Please explain in more detail what your ultimate Goal is:

Do you want a vba script to enter all the Dates in current month into column one of sheet named Alpha. And clear all dates in this column 1 previously entered.

I reconfigured the worksheet and its all good. Thank you. And yes, I used VBA.