Do I use a COUNTIF or a IFERROR(INDEX(MATCH formula??

I don't see any in your sample that go over 1 day anyway. And if there are some, we may have problems with all that we did previously to chart the data.

Bummer...Then for now nm. Yea, the sample was just that. But I thought it might be nice for them to enter a single event (start and end date) verses entering a new one for each day. It is alight! I thought it might be a "simple" add.

Upon entering the first month here of September, I need to add a minimum of 3 rows daily to the weekly calendar. Upon doing so, the Day of the week change and are not in sequential order. Formulas are good and match previous versions, but why is this happening?

(Ex) add 3 rows to Monday and the following day "Tuesday" now becomes "Wednesday" without any formula change.

It's because of the formula used to determine the date.... it is dependent on row numbers between.

Wow! So sorry! It sure does! :ranger:

~Thanks again