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,
Bookmarks