help needed in converting date format

[kiwis]

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

 

[Guest]

Sub formatdates()
ActiveSheet.Select
Columns("B:B").Select
Selection.NumberFormat = "mm/dd/yyyy"
Range("B1").Select
End Sub