98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Automatic Date Filling
Automatic Date Filling
Resolved · High Priority · Version 365
Tue 15 Nov 2022, 15:16Delegate 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:40Trainer 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:How to Spell Check an Excel 2010 WorksheetExcel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet. |
