date excel

[ginowine]

Dear people,

Is there a way to enter only the numbers of the day at column D and E and that the formula knows that I mean month January or at E month February and if at B2 I change the year to e.g. 2021 that the year at column D and E also change automatically with the entered date? My intention is with my cash book when I am busy with January, that I only enter numbers for the days and that I can also change it every year by changing the year of the entered dates. someone made date2 for me but without explanation. I am a beginner. how do I enter that in my own excel

Sincerely,

[arlu1201]

Hello ginowine,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[ginowine]

thank you very much alru1201

[JeteMc]

Hello ginowine and Welcome to Excel Forum.
You have posted a question in a forum that is set aside for making introductions. Please repost your question in one of the Microsoft Office Application Help - Excel Help forums
Let us know if you have any questions.