• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Required to complete Year Calender

ShoaibAli

New Member
Dear Team,

I have made this calendar but do not know how to include month 2020 which is in sheet12.

All i want is that when i change the year in sheet12 then automatically calendar dates should be changed.
 

Attachments

  • boobk2123.xlsx
    1,004.5 KB · Views: 9
Ex: In B1 of Feb sheet. Copy across.
=IFERROR(DATEVALUE(Sheet12!$I$3&"-"&"02"&"-"&COLUMNS($A$1:A1)),"")

Change "02" to appropriate month for each sheet. You can make this part dynamic, but that would make formula volatile.
Since this section only needs to be set up once per sheet. There really isn't need to make it dynamic.
 
Back
Top