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

automatic date filling

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

Automatic Date Filling

ResolvedVersion 365

Joseph has attended:
Time Management course
Excel Intermediate course
Excel Advanced course
Introduction to Management 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.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.