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.
use find and replace toolvto replace 2019 with 2020
ctrl + H to use find and replace tool, find 2019, replace with 2020
- can you send the original file , instead of .jpg form? just asking.
So here I created a sample table (sheet 1) how I did it all the time.
If you turn to sheet 2, I tried what Sergej had suggesting to me.
Now my question is, how will that work if I wish to switch that sheet 2 to 2020 with only adjusting one entry? I have to connect the days of the week to the dates, but how to, please? But that will not be the last step...
- "Find and replace tool"?
Sorry, apparently I am not that deep into Excel....
Maybe I've heard of that, and never learned what it is.
Please could you explain in smaller steps. Thank you.
