Date entered not matching date selected

[jgcramer]

I have a user form that has two listboxes for dates an order date and requested ship date. I wanted to only show the next 12 months in the list box so I have this to populate the listboxes

Please Login or Register  to view this content.

And then have this to enter the information selected

Please Login or Register  to view this content.

But for some reason the date that is entered is always the current year and not the one selected. Is that because i am only adding months to the current date? not sure how else to go about this, any help you could give me would be greatly appreciated

[JosephP]

perhaps change the date format in the listboxes to use a 4 digit year so that excel cannot misinterpret it

[jgcramer]

That did it! Thanks