Calendar formatting using conditional formatting (week, month and special days)

Calender.jpg



Hello,

I am trying to make a calendar as shown in the above picture.

Idea is to calendar by simply dragging the cells but want the formatting to be updated automatically as shown in the picture.

Is something like this possible using simple formulas in Excel? (Idea is to add formula to format the next cell when I want to expand the calender.

I am a beginner hence would like to stay with basic formulas.

Complex programing, I might not be able to comprehend at this moment....

Looking forward for solutions, Thanks very much in advance.

Hello Neil,

"IT'S PERFECT......"

I don't yet know how you did it, but this exactly what I was looking for. Thanks a lot for for sharing the file.
I will try to study your file and figure it out. And also start building on this file for furthur customization.

Again... Thanks a million.

Regards
Vikey