Date and month, linking cells

T_W

Hi there

I'm linking cells from numerous sheets to one specific. 

Most of the cells are containing dates. When linking, I have realised that month and date have switched places. Not all dates/cells, but in some cases. See below example. 

Original work sheet: 03/06/19 

Linking work sheet: 06/03/19

I've double checked the settings in both sheets, and they are the same (Europe - DK).

I also tried to convert all cells to US dates, but there are still irregularities - just the other way around.

Does anyone know if this can be fixed or is it a bug?

Help!

 

Andrée Starå

Hi,

Are all dates in date columns or could there be numbers or text?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Katerina

I am having the same problem. both columns are date columns.