Dear friends,

I have a column for date in many worksheets formatted as dd/mmm/yy. I know I can use ctrl+; to enter today date like 24-jun-15. I have to enter 23/6 to display 23-jun-15. Is there any settings in excel if I enter only 22 it should display the date with the current month like 22-jun-15 and 17-jun-15 for entering only 17. But now if I enter 22 it displays 22-jan-00. I have to enter bunch of data in month end. So I always need date only for current month. Please provide is there is any solution. Advance thanks