I am working with dates of death and burial. Not always is the burial date known, hence if death was 01 Feb 2020 then burial is aft 01 Feb 2020.
Column is formatted Date = DD Mmm YYYY so entering “aft” doesn’t work. Must I sacrifice formatting as date and switch all to text?
MacOS LibreOffice 28.4.2
Here you should use conditional formatting. Your case is exactly matching its idea: if the cell to the left is blank, then apply a specific number format to the current cell, which is not DD Mmm YYYY, but "aft "DD Mmm YYYY.
Having 2 columns would still mean not being able to sort, I assume?
I may have missed the sample data you provided in your question; curiously, my browser doesn’t show that sample file. No idea how your actual data is organized, and what specifically is needed to sort.
No, you can still sort by death column.
.
It seems you with to enter your aft in the same column as the date, so you would mix 2 informations (a date and a property “after”). This will not be possible (edit: together with sorting as date)
Possibly the easiest is having a dedicated column just for an optional textual “aft”.
Seems I’m probably creating a problem for myself. Will use the death date only given it is usually 1-10 days later. Only writing this post do I realize the death date will suffice.
I’m going to use the death date only. Will have to figure out dates that are only a year (do not want to fill in as 01-01-2001) but at least I can sort.
Need the sort as the date of event determines proper place hierarchy for where they were born/married/died/buried.
