Thread: Combine day text and date problems
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default Ignore
Go the long way around..

=month(A2)&"/"&day(A2)&"/"&year(A2)&" "&A1

"mike" wrote:

Ignore this...

A1: Wednesday
A2: 10/1/2008

Results: Wednesday 39722

Reply With QuoteReply With Quote