Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel FORMULATEXT function
  • Offset in Excel
  • Vlookup Examples in Excel
  • How to use Excel TRANSPOSE Function
  • Excel Advanced Lookup using Index and Match Functions

Data Analysis Examples

  • How to sum a total in multiple Excel tables
  • How to count table rows in Excel
  • Create Scatter Chart in Excel
  • Understanding Pivot Tables in Excel
  • How to create running total in an Excel Table

Data Validation Examples

  • Excel Data validation exists in list
  • Excel Data validation must not contain
  • Excel Data validation date in next 30 days
  • Excel Data validation must begin with
  • Data validation must not exist in list

How to calculate Quarter of Date in Excel

by

An easy formula that returns the quarter for a given date. There’s no built-in function in Excel that can do this.

1. Enter the formula shown below.

Explanation: ROUNDUP(x,0) always rounds x up to the nearest integer. The MONTH function returns the month number of a date. In this example, the formula reduces to =ROUNDUP(5/3,0), =ROUNDUP(1.666667,0), 2. May is in Quarter 2.

Worked Example:   Floating Point Errors in Excel
Worked Example:   How to calculate percent variance in Excel

2. Let’s see if this formula works for all months.

Explanation: now it’s not difficult to see that the first three values (months) in column B are rounded up to 1 (Quarter 1), the next three values (months) in column B are rounded up to 2 (Quarter 2), etc.

Worked Example:   Find Percentage Change Between Numbers

Post navigation

Previous Post:

How to Separate Text Strings in Excel

Next Post:

How to get Holiday Date from Year in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Remove text by variable position in a cell in Excel
  • How to split text with delimiter in Excel
  • Remove text by position in a cell in Excel
  • Replace one character with another in Excel
  • How to split text string at specific character in Excel
  • Calculate number of hours between two times in Excel
  • How to get same date next month or previous month in Excel
  • Convert Excel time to Unix time in Excel
  • Count dates in current month in Excel
  • Get days before a date in Excel
  • SLN function: Description, Usage, Syntax, Examples and Explanation
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • NPER function: Description, Usage, Syntax, Examples and Explanation
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • COUPNCD function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles