Date Entry Tricks
When entering dates from the current calendar year you can leave out the year. Excel assumes the current year.
Entering 27/7 and pressing Enter will enter 27/7/16. I wrote this post in 2016.
Whatever you enter is first considered as dd/mm. If that doesn’t make sense eg 9/15 then mm/yy if used.
If you enter a month and year combination it assumes the first of the month.
For example entering 9/15 will enter the 1/9/15.
You can use the forward slash / or the dash – between values in a date and Excel will recognise the date.
Excel treats 9/15 the same as 9-15.
To entry today’s date use Ctrl + ;