Hey guys, I've searched high and low for a solution to this, and as a
last resort, I've come to the forums for some help.

For range C1:ZZ3 , I have the following formulas,

C1 : =IF(DAY(C$3)=1,CHOOSE(MONTH(C
$3),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG ","SEP","OCT","NOV","DEC"),"")

C2: =CHOOSE(WEEKDAY(C$3),"S","M","T","W","T","F","S")

C3: = DATE + 1 (Incrementing the initial date by 1 as you progress
through the columns)

Now, please bare in mind I have simplified the issue to help me
explain this, but here it is:

I am actually only talking about the first row here,

If I paste the formula all the way across, most cells will be "" blank
cells because the month only shows up at the first of every month. So
lets say it's the first of the month and cell C1 would be "JULY", only
the "J" is visible because the formula in C2 cuts it off. How can I
make it so that blank formula results will have transparent cell
formats so that the entire text of JULY is visible without it being
cut off by the following cell? How can I correct this problem? If
anyone can help with this, I will be very grateful! Thank you!

-Naji

You have lots of replies at your other post.

Naji wrote:

Hey guys, I've searched high and low for a solution to this, and as a
last resort, I've come to the forums for some help.

For range C1:ZZ3 , I have the following formulas,

C1 : =IF(DAY(C$3)=1,CHOOSE(MONTH(C
$3),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG ","SEP","OCT","NOV","DEC"),"")

C2: =CHOOSE(WEEKDAY(C$3),"S","M","T","W","T","F","S")

C3: = DATE + 1 (Incrementing the initial date by 1 as you progress
through the columns)

Now, please bare in mind I have simplified the issue to help me
explain this, but here it is:

I am actually only talking about the first row here,

If I paste the formula all the way across, most cells will be "" blank
cells because the month only shows up at the first of every month. So
lets say it's the first of the month and cell C1 would be "JULY", only
the "J" is visible because the formula in C2 cuts it off. How can I
make it so that blank formula results will have transparent cell
formats so that the entire text of JULY is visible without it being
cut off by the following cell? How can I correct this problem? If
anyone can help with this, I will be very grateful! Thank you!

-Naji

--

Dave Peterson

I mean, D2 cuts it off, sorry.

Naji wrote:
Hey guys, I've searched high and low for a solution to this, and as a
last resort, I've come to the forums for some help.

For range C1:ZZ3 , I have the following formulas,

C1 : =IF(DAY(C$3)=1,CHOOSE(MONTH(C
$3),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG ","SEP","OCT","NOV","DEC"),"")

C2: =CHOOSE(WEEKDAY(C$3),"S","M","T","W","T","F","S")

C3: = DATE + 1 (Incrementing the initial date by 1 as you progress
through the columns)

Now, please bare in mind I have simplified the issue to help me
explain this, but here it is:

I am actually only talking about the first row here,

If I paste the formula all the way across, most cells will be "" blank
cells because the month only shows up at the first of every month. So
lets say it's the first of the month and cell C1 would be "JULY", only
the "J" is visible because the formula in C2 cuts it off. How can I
make it so that blank formula results will have transparent cell
formats so that the entire text of JULY is visible without it being
cut off by the following cell? How can I correct this problem? If
anyone can help with this, I will be very grateful! Thank you!

-Naji