Thread: Extracting date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Extracting date

=F1 and format as mm/yyyy ?

Or, of course, you can format F1 as mm/yyyy, input the data as mm/dd/yyyy,
and then you wouldn't need G1.
--
David Biddulph

"Pietro" wrote in message
...
Hi all,
I have a cell,let's say F1,where users can input the date formatted
mm/dd/yyyy,i need that G1 automatically views the part mm/yyyy extracted
from
F1.
Can anybody help ?!