Hi all,
I have a large stack of papers containing "start" and "end" dates that require data entry into excel. These dates are written in the following format:
YEARMMDD, where MM is a two letter code for each month (e.g. SE is september, OC is october, etc).
For example, start date: 2020SE10 end date: 2020SE14.
Rather than mentally converting this data into one of Excel's built-in formats, is there a way to define this custom format so that excel recognizes it? One that would also allow me to perform operations such as:
=DATEDIF(2020SE10,2020SE14,"d")
Thank you
Bookmarks