Automatic Date Filling

Resolved · High Priority · Version 365

Tue 15 Nov 2022, 15:16 Delegate Joseph said...

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!

Wed 16 Nov 2022, 09:40 Trainer Marius said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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