Date entry where part of date is unknown

[MBernard]

Hello

I am cataloguing letters. I have full day-month-year information for most, but:

-- a few have only a month and year (e.g. 11/1933)
-- a few have only a year

How can I enter these so that, when I sort by date, they appear in the appropriate place, e.g.

07/09/1933
10/1933 (day of month unknown)
02/10/1933
1934 (day and month unknown)
27/04/1934

You will see from the above that I am using European date format; I don't know whether that makes a difference.

Thanks,

Mary

[NBVC]

perhaps you can try adding a helper column with formula:

=IF(LEN(A2)=4,DATE(A2,1,1),DATE(YEAR(A2),MONTH(A2),DAY(A2)))

where A2 contains first date... and then sort by that column.

This replaces the date and/or month with 1's.