Months to quarters

[simonstone]

A sales database processes reports that can both we monthly or quarterly.

For the quarterly ones the data can be presented in the following format:

"Jan-18,Feb-18,Mar-18"

Is there a formula that could recognise such a string and product a result (in this example):

"Q1-18"

Thank you.

 

[mole999]

Have a read here > https://www.mrexcel.com/forum/excel-questions/1083250-date-quarters.html?highlight=quarters

 

[simonstone]

Thanks mole999. That's perfect.