Excel VBA Date and Time Picker

[doeljeen]

Hi all, I am a new member here but I have visited this forum before to look for helpful solutions.

Sadly, I cannot seem to find a thread for this one: my date and time picker outputs not dates but numbers albeit not random, and I do not know how to make it display real dates.

When I pick today's date(5/22/2018) it outputs 43242, when I pick yesterday's date(5/21/2018), it outputs 43241. I am very new to coding in VBA and I have no idea how to fix this. Any help would be greatly appreciated. Thanks.

 

[Rick Rothstein]

Re: Need Help: Excel VBA Date and Time Picker

Hi all, I am a new member here but I have visited this forum before to look for helpful solutions.

Sadly, I cannot seem to find a thread for this one: my date and time picker outputs not dates but numbers albeit not random, and I do not know how to make it display real dates.

When I pick today's date(5/22/2018) it outputs 43242, when I pick yesterday's date(5/21/2018), it outputs 43241. I am very new to coding in VBA and I have no idea how to fix this. Any help would be greatly appreciated. Thanks.

That number is the number of days offset from "date 0"... to convert it to a recognizable date, apply the CDate function to the output value.

 

[doeljeen]

Re: Need Help: Excel VBA Date and Time Picker

That number is the number of days offset from "date 0"... to convert it to a recognizable date, apply the CDate function to the output value.

Oh. Thank you so much sir!