automatic date filling

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Automatic Date Filling

Automatic Date Filling

resolvedResolved · High Priority · Version 365

Joseph has attended:
Time Management course
Excel Intermediate course
Excel Advanced course

Automatic Date Filling

I have an excel worksheet that manages all the communications my company sends out, with each month, week, and day included to mark when emails are due to be sent in 2022. I am now trying to set up the 2023 version in advance of next year.

One of the columns we have is for 'Activity Date' i.e. when the event will take place - when I insert a date '1 Jan' for example, Excel automatically changes this to 01-Jan-22.

How can I make it so when I add "1 Jan" to a cell in this column, it automatically populates to the 2023 date instead of 2022? (E.g. 01-Jan-23.

Thank you!

RE: Automatic Date Filling

Hello Joseph,

Thank you for your question. In the dates column, for the first date, enter the date as follows, e.g.: 01/01/2023

Excel will then understand that you want 2023. (If you don't type the year, it defaults to the current year.)

Afterwards, you can format the date differently if needed.

I hope this helps.

Kind regards
Marius Barnard
STL

Wed 23 Nov 2022: Automatically marked as resolved.


 

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips


Server loaded in 0.53 secs.