# Return quarter number if columns dates fall between dates

✭✭

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?

• ✭✭✭✭✭✭

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?

• ✭✭

@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.

• ✭✭✭✭✭✭

Try this:

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!