Forum Discussion
Calendar in Excel
You may add in any sheet (here in third one) helper cell with the year and name it as, for example, CurrentYear
When first date for the current year will be
=DATE(CurrentYear,1,1)next one as
=A3 + 1For the day of the week you may repeat the date ( = A3 ) and apply to it custom format as
Please check attached.
It depends on how your current calendar table is built. In general
next date = previous date+1
and weekends could be highlighted by conditional formatting.
If such way you need only to change one starting date.
I'm not sure I understand, I'm afraid.
Of course "next day" is "actual day + 1".
My question is, if I have such a table in Excel for 2019, how can I build it to be able to convert it with one data entry from 2019 to 2020, and all data and week days will be adjusted?
If you have the table for 2019 where is only on date is hardcoded, e.g. 01 Jan 2019, when you may copy/paste it on 2020 and change this first date on 01 Jan 2020.
- Sorry, what do you mean by "hardcoded"?
I just have that table with all the dates, and in further columns (which I had cut from my screenshot example) the data assigned to the dates (horizontally) and other criteria (vertically).
Ok, how do I hardcode the date of, for example, Tuesday, Jan. 1st 2019, to be able to switch the calendar to 2020, and Jan. 1st will be then on Wednesday, and all the other dates are assigned to the correct day names?I mean that in your current calendar for 02 Jan 2019 you entered 02/01/2019 (or what is your locale format), not =A1+1 if in A1 is 01 Jan 2019.