I have a calculated column [Due date] with a simple formula, =[Event date]+13, and it's set to The data type returned from this formula is: Date and Time.
However, it doesn't have the Display Format: Standard / Friendly option that ordinary non-calculated Date and Time columns have. And I'd like it to use that friendly format.
Has anyone ideas for applying SharePoint's friendly date formatting to a calculated date column - e.g., with JSON column formatting, with something in the column's formula etc? I've seen some PowerShell snippets about friendly date formats but I'm hoping for something easier to manage.
Much obliged for any and all feedback!