Formula to Extract Date

[ben1991]

Hey,

I am creating an invoice worksheet which has orders with date and time details e.g. in the form 2006/12/03 at 22:15. I would like to extract the month and year from this data e.g. in the format 12/06, and display this in another cell in the worksheet. I am unsure of the code that would allow me to do this and would be grateful for any suggestions!

Thanks,

Ben

[daddylonglegs]

Will a formula do? If date/time is in A1 try

=TEXT(A1,"m/y")

[ben1991]

Sorry i meant to say formula That formula doesn't seem to work, it just reproduces the same data rather than copying the month and year only.

[ben1991]

It works if i remove the time part e.g. 2006/12/03 at 22:15, but I would rather keep the date and time together.

[daddylonglegs]

OK, I assumed you had a recognisable date/time format in the source cell, not text.

Assuming you always show the date with two digits for month and year try

=TEXT(LEFT(A1,10),"m/y")

or if you might show the month or day as single digits

=TEXT(LEFT(A1,FIND(" ",A1)-1),"m/y")

[ben1991]

Thank you for your help - the formula works perfectly!

Ben