You want day before month when entering date in excel ?
Well, you can swap or reverse day and month of date in Excel
If you want to change date format in excel to dd/mm/yyyy, please do as follows :
Select the date cells you will swap the days and months, and then press the Ctrl + 1 keys to open the Format Cells dialog box.
In the Format Cells dialog box, please click Custom in the Category box under Number tab. If the original date formatting is m/d/yyyy, please enter d/m/yyyy into the Type box, and if the original date formatting is d/m/yyyy, please enter m/d/yyyy into the Type box, and finally click the OK button. See screenshot:
Now the day and month are swapped in selected date cells.