Forum Discussion
Re: Sort by table chronologically in MS Excel when some date are DD/MM/YY and some are YYYY only
I think ideally yyyy would be better. This will be used a source data to be imported into MapMate, a biological recording software
This comes a bit late & what difference would this make given you have dd/mm/yyyy values in the [Date] column anyway?
10 Replies
- So with the above formula assuming the dataset is formatted as a Table, the entries can be sorted chronologically?
I think the difference would be that saying 31/12/1982 will export an incorrect date into the new software, where as just 1982 is accurate..
How can a person hire someone to do this is way beyond anything I can understandSo with the above formula assuming the dataset is formatted as a Table, the entries can be sorted chronologically?
Yes, see sheet 'DataSorted'
I think the difference would be that saying 31/12/1982 will export an incorrect date into the new software, where as just 1982 is accurate
OK, so see last workbook I shared
- I've just seen the data sorted - thanks
So they paper version the typist is typing can be in one tab per species and then the second tab can sort the data she has typed.
