Auto creating a calendar based on a date in a cell.

I am playing around with creating a calendar based on a date (month) I enter into a cell.

I am doing this with a simple =date+1

I have a sample attached. Only problem I am having is that for months with 30 days I don't want the last day to show the first of the next month. But I can't simply remove that as if I entered a month with 31 days I would need it to show the 31st.

thanks for any help.

Nick

Starting in G8 (because of Feb and Leapyears), dragged to the right, I'd use this formula

Please Login or Register  to view this content.

Does that work for you?

Actually, when working with months of less than 30 days (ummm Feb), it gives errors on the 30th and 31st. Use this formula instead

Please Login or Register  to view this content.