Hi

I need some help with the date format.

I have date in dd/mm/yyyy format & i want to find the age of the
product.
I think i need to change the date to mm/dd/yyyy before i can use my
formula
to find the age.

sample of my data what i need i think
column b column c
25/12/2002 12/25/2002
5/2/2001 2/5/2001

how do i write a macro to convert the date to the format i want?

any ideas or solutions is welcomed

Thank you

rgds
kiwis