Hi

i have date in dd/mm/yyyy format, i need to find the age of the
product but
i think i need to convert the date to mm/dd/yyyy format 1st before
using the formula
to find the age of the product.

sample data final result
column b column c
28/12/2003 12/28/2003
2/5/2001 5/2/2001

i need to write a macro to change column b to the output shown in
column c.

How do i go abt doing writing this ?

ANy ideas or sample code to share?

Thank you

rgds
kiwis