Date format error for SUMIFS

Hi,

Im using a Textbox in a userform which will auto populate previous month in format MMM-YY and once I give save it will save it in sheet1. It displays me in the same MMM-YY for Jun-16 but when I click on the cell its in format 16-06-2016.

Here is the code

Please Login or Register  to view this content.

Based on that cell I need to put SUMIF formula but my output is not accurate due to this format. But if it displays as 01-06-2016 for Jun-16 im getting accurate result in SUMIFS.

Can anyone let me know the solution for this?

Thank you so much Kamboj. Its working perfect.