Conditional formatting of date
I'd like to format a date field like this:
if the date is less than 60 days from today, show the dd-mmm-yyyy
if the date is less than 1 year away and greater than 60 days from today, show the mmm-yyyy
if the date is more than a year from today, show Q1-yyyy, Q2-yyyy etc.
Can this be done with a script or function?