Return quarter number if columns dates fall between dates

JoAnneA

I am trying to identify quarters based on dates

If DATE in Column (@row) is between DATE A and Date B on other sheet put in Q1

How would you formulate this?

Paul Newcome

Are you able to provide some screenshots for reference? Are the dates variable each year or is it always (for example) Jan 1 - Mar 31 is always 1st quarter?

JoAnneA

@Paul Newcome , The dates are the same - I even tried putting them into a separate sheet to build into the formula.

for now, I put the quarters in manually. I want to look at Go Live Date Calculated to return the Quarter in which the Go-Live Falls. Here is a screenshot and below I put in a screenshot of the sheet I defined the quarters in.

Paul Newcome

Try this:

=RIGHT(YEAR([Go Live Date Calculated]@row), 2) + "-" + ROUNDUP(MONTH([Go Live Date Calculated]@row) / 3)