Date format is changing from one sheet to other
I have two sheets ,In sheet1 there is a start date field in the format DD/MM/YYYY . In the sheet2 i have a date filed which is linked via cell linking to sheet1 but the date is appearing in a different format in sheet2 - MM/DD/YYYY . why is the date format getting changed?
Please see the attachments