Forum Discussion

wire1's avatar
wire1
Copper Contributor
Dec 19, 2019
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...
excel
Formulas and Functions
Macros and VBA
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 20, 2019

    wire1 

    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 + 1

    For the day of the week you may repeat the date ( = A3 ) and apply to it custom format as

    Please check attached.

Saty_Rana's avatar
Saty_Rana
Brass Contributor
Dec 19, 2019
use find and replace toolvto replace 2019 with 2020
wire1's avatar
wire1
Copper Contributor
Dec 19, 2019
"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.

Resources