Calendar Off by One Day

Hello,

On my 'Select Month View' the calendar days are off by one. Does anyone know why and how to fix please?

Thank you very much,
Billy

So, for Wednesday:

=IF(WEEKDAY(DATEVALUE(MoMonth&" 1, "&MoYear))=COLUMN(E$1),1,IF(LEN(E4)>0,E4+1,""))

This is looking for the WEEKDAY function to return 5 (the number of column E), which is the wrong day (5 = Thursday). Because you have added extra columns, the formulae are out of whack. The bit in red must advance by one column only as you copy it across the row.

I will give it a go thanks so much. I knew I messed up somewhere.

I made it work but not sure if it's correct:

B4:

=IF(WEEKDAY(DATEVALUE(MoMonth&" 1, "&MoYear))=COLUMN(A$1),1,IF(LEN(A4)>0,A4+1,""))

C4 & D4:

=IF(WEEKDAY(DATEVALUE(MoMonth&" 1, "&MoYear))=COLUMN(B$1),1,IF(LEN(B4)>0,B4+1,""))

Then I added one letter for each across.

see attached file.
It was easy enough to manually fix the formula.

Thank you modytrane that works great!

Yes, hard-coding the day numbers is the safest way to do it here. I wanted you to understand what you'd done to cause it to fail, though.

I appreciate the lesson as always.