Thread: Extracting date from Date and Time formatted cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Davesexcel Davesexcel is offline
external usenet poster
  
Posts: 7
Default Extracting date from Date and Time formatted cell
You can use..
=TEXT(A1,"mm/dd/yyy")

or
=A1 and then format the cell to the date format
Reply With QuoteReply With Quote