Date Display

M

Mike H.

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!
 
M

Mike H

Try this with a date in A2

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

Mike
 
S

Stefi

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


„Mike H†ezt írta:
 
Top