Date Display

  • Thread starter Thread starter Mike H.
  • Start date Start date
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!
 
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
 
Why not
="No posting before " & TEXT( A2,"dddd,,mmm,dd,yyyy")
Regards,
Stefi


„Mike H†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Month & Year of Date Value 1
Cell Format Defaults to a Formula 2
Extract month from date 2
How can I use OFFSET and VLOOKUP together 1
If statement with dates 0
Stupid Question 1
Dates and days of the week 3
Excel Vba to change displayed year automatically. 14

Back
Top