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 + ;


Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.