Curious Cat
New Member
- Joined
- Mar 25, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
I have a list of magazines by release date in a column as Jan-20, Feb-20, etc. These are straightforward to sort, however I want to inculde seasonal editions in this list too that will be tied to a particular date without having to add in a second column. Is there any workaround that get it to recognise winter, summer, spring and autumn as a set date and display that text instead of the date where relavent? E.g. so if I could put in 1 March 2021 I'd get the date as Mar-21, but if I entered 2 March 2021 instead of getting the date it would convert it to Spring?