convert dates excel vba

[rakesh seebaruth]

Hi Guys

I have the following link https://www.dropbox.com/s/g9t6l9sgp3j4l9d/testing223.xlsx?dl=0
in which i have dates which i need to be converted. Expected results are shown cells B2 and C2.

I need a vba code to convert the given dates into the required formats

Thanks/regards

rakesh