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