Date error: 29/2/2023 shows Wed 01/03/2023

Hi All,

I have 3 textboxes for date inputs for DD, MM and YYYY.
(FYI, I cannot use any addin or ddl due to company policy, so I had to create add-in and ddl free date input in the UserForm.)

Issue:
If user puts 29/02/2023. the result shows me incorrect output as Wed 01/03/2023.

Please Login or Register  to view this content.

Can someone please let me know that how to avoid this date issue. I want that if user puts incorrect date then this formula should not display the dayname on a target label "Format(DateSerial(TextBoxYY.Text,TextBoxMM.Text,TextBoxDD.Text), "DDD")"

Why do you think that's wrong? 2023 doesn't have 29 days in February, so Excel calculates the correct date.

You would need to compare the month of the date calculated to the month in the text box.

Some thing like this:

PHP Code: 

if month(DateSerial(TextBoxYY.Text,TextBoxMM.Text,TextBoxDD.Text)) <> TextBoxMM.Text then
     Msgbox "wrong day - month"
     exit sub
End if 


Thank you @bebo021999 for the logic with code!
Thank you @TMS for sharing thoughts/idea!

You're welcome. Thanks for the rep.