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
InputMY.Value = Format(DateSerial(Year(Date), Month(Date) - 1, 1), "mmm-yy")
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?