Forum Discussion
Solved
Calendar in Excel
Hi. At the Job we have some statistics covering the entire year. Basically, it's a calendar type of table where you add specific values each working day. Now, one year is done, and you need a simil...
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.
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 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.
- Please, could you give me this as a formula? At work, I don't have much spare time to try many things out and see if I win or fail. Sorry.