Date Picker has same dates, need advice

[Yoichi]

Hi,

The following post might help you.

How to automate date picker with week inside the date picker?

Hi, Can you try the following steps? First, create DateTime variable from the string : dateVar = CDate("23 May 2022") Then CInt(dateVar.DayOfWeek) returns weekday number such as Sunday is 0, Monday is 1 etc. We can use it as ColumnIndex. And (dateVar.Day+New DateTime(dateVar.Year,dateVar.Month,1).DayOfWeek-1) \ 7 returns week number of the month: for example 1 May 2022 is 0, 23 May 2022 is 3. So we can use it as RowIndex. As a result, we can strictly indicate element using above both…

Regards,