Date Display
 

I want to have a cell display on the screen this:
Note: No Posting before Wednesday, January 2, 2008

and the cell would be the next "Note: No Posting before " concatenated with
a cell that has the date in it. But I can't get the formatting right. Can
someone help!

Date Display
 

Try this with a date in A2

="No posting before " &
CHOOSE(WEEKDAY(A2),"Sunday","Monday","Tuesday","We dnesday","Thursday","Friday","Saturday") &" "& TEXT( A2, "mmm,dd,yyyy")

Mike

"Mike H." wrote:

I want to have a cell display on the screen this:
Note: No Posting before Wednesday, January 2, 2008

and the cell would be the next "Note: No Posting before " concatenated with
a cell that has the date in it. But I can't get the formatting right. Can
someone help!

Date Display
 

Why not
="No posting before " & TEXT( A2,"dddd,,mmm,dd,yyyy")
Regards,
Stefi


€žMike H€� ezt Ã*rta:

Try this with a date in A2

="No posting before " &
CHOOSE(WEEKDAY(A2),"Sunday","Monday","Tuesday","We dnesday","Thursday","Friday","Saturday") &" "& TEXT( A2, "mmm,dd,yyyy")

Mike

"Mike H." wrote:

I want to have a cell display on the screen this:
Note: No Posting before Wednesday, January 2, 2008

and the cell would be the next "Note: No Posting before " concatenated with
a cell that has the date in it. But I can't get the formatting right. Can
someone help!