I used the calendar code and missed two days

[Sxbbb]

I fetch data from excel The latest date is 10/02/2023.

use code

Result

But I use this formula for my calendar.

But the dates 09/02/2023 and 10/02/2023 disappeared

I need E_Date and E_Day data for Listbox.

But the dates 09/02/2023 and 10/02/2023 disappeared

[sidhiq91]

@Sxbbb  It is Strange. I don't see any issue why it is getting disappeared. Could you please post the sample date excel. Let me give a try once from my end as well?

[Sxbbb]

normally no problem

Date 09/02/2023

 Run through without error