Help with Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, hope someone can help me.
I have a column (column A) of dates in my spreadsheet in the following
format DD/MM/YYYY what I would like is formula in column B that will look at
the date in column A and take off the DD so I will ultimatly have two columns
e.g.

Column A Column B
12/01/2004 01/2004
25/08/2005 08/2005
26/09/2005 09/2005

Many Thanks
 
Try this.

Where your list starts in A1 in B1 type.


=TEXT(A1,"mm/yyyy")

Copy down your list.



Cheers,

Stev
 
Custom format Column B to:
mm/yyyy

Then in B1 enter
=A1

And copy down.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top