Hi,

I am looking to combine these two functions but it does not seem to be working...

the beginning of my F3 cell is:
04/01/2010

04 represents month, 01 represents day, 2010 represents year

I'd like to pull that out into a date format in another cell

my formula I have is : =date(right(F3,4)|left(F3,2)|mid(F3,2)) but it doesn't work

Does anyone have an idea why?