Extracting date

[Pietro]

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 ?!

 

[David Biddulph]

=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.

 

[Sandy]

Try =TEXT(F1,"mm/yyyy")

Sandy