End of Quarter

Last day of that calendar quarter.

Returns the last local day of the quarter that contains one date. Unlike Start of Quarter this is the end. Unlike End of Month this is a quarter boundary. Invalid dates fail.

What End of Quarter does

Returns the last local day of the quarter that contains one date. Unlike Start of Quarter this is the end. Unlike End of Month this is a quarter boundary. Invalid dates fail.

End of Quarter sits in the Date & time group on purpose. It is not Start of Quarter (First day of that calendar quarter.) and not Quarter Range (First and last day of that quarter.). Choose this page when you need Last day of that calendar quarter. If you stretch End of Quarter into a neighbor’s job, the result will look wrong even though the site chrome looks the same.

How to use End of Quarter

  1. Confirm you need End of Quarter, not Start of Quarter (First day of that calendar quarter.). Address: /datetime/end-of-quarter.
  2. Enter the numbers or dates End of Quarter uses. Last day of that calendar quarter.
  3. Read the result as End of Quarter defines it — not as Quarter Range (First and last day of that quarter.). Returns the last local day of the quarter that contains one date. Unlike Start of Quarter this is the end. Unlike End of Month this is a quarter boundary. Invalid dates fail.
  4. End of Quarter is an estimate in the browser, not professional advice. Last day of Q1–Q4. Invalid dates fail.
  5. Need a different formula? Try Quarter Range (First and last day of that quarter.) instead of stretching End of Quarter.

When not to use End of Quarter

Skip End of Quarter when a neighbor tool matches better — start with Start of Quarter or Quarter Range — or when the description already warns the job will fail. In the tool’s own words: Returns the last local day of the quarter that contains one date. Unlike Start of Quarter this is the end. Unlike End of Month this is a quarter boundary. Invalid dates fail.

Questions about End of Quarter

What does End of Quarter do that other Date & time pages on this site do not?
Returns the last local day of the quarter that contains one date. Unlike Start of Quarter this is the end. Unlike End of Month this is a quarter boundary. Invalid dates fail. Short version: Last day of that calendar quarter.
Does End of Quarter upload my file or text to Tool-You servers?
No. End of Quarter runs in this browser tab. Files stay on the device. Limit note: Last day of Q1–Q4. Invalid dates fail.
Should I use Start of Quarter instead of End of Quarter?
Use End of Quarter when you need Last day of that calendar quarter. Use Start of Quarter when you need First day of that calendar quarter. They share a category (Date & time) but not the same job.
What are the limits of End of Quarter?
Last day of Q1–Q4. Invalid dates fail. Also: Returns the last local day of the quarter that contains one date. Unlike Start of Quarter this is the end. Unlike End of Month this is a quarter boundary. Invalid dates fail.