I’m doing a list of recurring (yearly) events from 1/jan to 31/dic, without the year: insurance expirations.
If I insert 1/1 and the format cell adjusts to 1/jan but the cell value is also adjusted to 01/01/2018.
I need the cell values to be 01/01 to prevent sorting problem when I put new line the next years.