Date format gets reversed !

boscod35

Hi Community,

I need the date set to be dd/mm/yyyy, My system settings are also the same. The problem I encounter is that whenever I do a cell reference and pull the information from a reference sheet, the format gets changed to MM/DD/YYYY. Due to which unable to filter the summary of data for each month and had to do a manual correction to generate the report.

I checked the Smartsheet date format too - it is set as below.

Date format reversed dd/mm/yyyy to MM/DD/YYYY - Is there a Formula to verify the date? Please advise.

Thanks in advance,

Don.

Jeff Reisman

@boscod35

Can you tell us how the date on the reference sheet is getting there (manual entry, formula, etc?)

Also please show us the formula you are using the pull the date values in from your reference sheet.