Formulas for yearly calendar

Hi all,

I am trying to create a dynamic yearly calendar in excel.
I found a sample online and changed according.
It's working for the month of January, but it's not working for February onwards.

Can anyone please have a look for me or siggest something else better?

Thanks!

Note: I used named ranged

Hi Kaper,

Thank you very much!
Though I still dont understand the logic behind, will spend more time to explore.

Thanks again!

Take a look at this thread:

http://www.excelforum.com/tips-and-t...enerators.html

for a few others that you could download.

Hope this helps.

Pete