Thread: How do I show the day and date in excel in the same cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Flintstone
 
Posts: n/a
Default How do I show the day and date in excel in the same cell

Assuming your ariginal date is in cell A1, paste this in cell A3 and
copy down as far as needed.

=TEXT($A$1+ROW()-2,"ddd, m/d/yyyy")

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=515742

Reply With QuoteReply With Quote