Easily Create a Calendar in Excel (Step by Step)

Learn to create a calendar in excel step by step. This is a very easy way to make a customized monthly calendar. When you change month or year the calendar changes.

Here is my Formula :
IF(ROW(A3)=3,IF($C$1=COLUMN(A3),1,IFERROR(IF(OFFSET(A3,0,-1)="","",OFFSET(A3,0,-1)+1),"")),IF(COLUMN(A3)=1,INDIRECT("G"&ROW(A3)-1)+1,OFFSET(A3,0,-1)+1))

#Excel_Series is a comprehensive video series of Microsoft Excel tutorials by The Akshay.

[callumhewson]

i can't see all of the formula, can you display all of it please, the last bit is not showing???

[tamilan]

SAME TYPE IS WORK PROPER, COPY PAST NOT WORKED PROPER