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