Tried that, but the text gets truncated as the adjacent cell is not
empty, so cell contents displayed as #
I've changed forumula to
IF(MONTH(E$2)<MONTH(D$2),TEXT(E$2,"MMM"))

I have a start date in Cell A1 and then in the scheduling section, cell
B2=A1, C2=B2+1, etc.
Cells B3:... are =Text(B2,"ddd") with conditional format, pattern=grey
if value ="Sat" or "Sun"

I've not done much with PivotTables, but they may offer a solutiuon, so
I'm going to look into that.
-ao-