Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Managing Conditional Formatting Rules in Excel
  • How To Compare Two Lists in Excel
  • How to calculate current stock or inventory in Excel
  • Error Bars in Excel
  • Example of COUNTIFS with variable table column in Excel

References

  • How to get first row number in range in Excel
  • How to use Excel TRANSPOSE Function
  • Approximate match with multiple criteria in Excel
  • How to get last row in numeric data in Excel
  • How to use Excel MMULT Function

Data Validations

  • Data validation must not exist in list
  • Excel Data validation only dates between
  • Excel Data validation date in specific year
  • Excel Data validation must begin with
  • Excel Data validation with conditional list

Tag: MONTH function

MONTH function: Description, Usage, Syntax, Examples and Explanation

by

What is MONTH function in Excel? MONTH function is one of Date and Time functions in Microsoft Excel that returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December). Syntax of MONTH function MONTH(serial_number) The MONTH function syntax has the following arguments: Serial_number    Required. …

Continue Reading

How to determine year is a leap year in Excel

by

If you want to test whether the year of a certain date is a leap year, you can use a formula that uses the MONTH, YEAR, and DATE functions. Formula =MONTH(DATE(YEAR(date),2,29))=2 Explanation In the example shown, the formula in cell C5 is: =MONTH(DATE(YEAR(B5),2,29))=2 How the formula works The core of this formula is the DATE …

Continue Reading

How to generate series of dates increment by 1 year from a single start date in Excel

by

If need to generate a dynamic series of dates with a formula that increase by one year from a single start date, you can do so with a formula that uses the DAY, MONTH, YEAR, and DATE functions. Formula =DATE(YEAR(date)+1,MONTH(date),DAY(date)) Explanation In the example, B6 is the hard-coded start date and the formula in B7 …

Continue Reading

Add years to date in Excel

by

If you need to add years to date in Excel then this tutorials is for you. See the example below . To add a given number of years to a date, you can use a formula based on the DATE function, with help from the YEAR, MONTH, and DAY functions. Formula =DATE(YEAR(date)+years,MONTH(date),DAY(date)) Note: if you need …

Continue Reading

Count birthdays by month in Excel

by

This tutorial show how to Count birthdays by month in Excel using the example below. To count the number of birthdays in a list, you can use a formula based on the SUMPRODUCT and MONTH functions. Formula =SUMPRODUCT(–(MONTH(birthday)=number)) Explanation of how this formula works In the example shown, E5 contains this formula: =SUMPRODUCT(–(MONTH(birthday)=D5)) This formula counts …

Continue Reading

Steps to create Dynamic calendar grid in Excel

by

This tutorial show how to  create Dynamic calendar grid in Excel using the example below. You can set up dynamic calendar grid on an Excel worksheet with a series of formulas, as explained in this article. Explanation of how this formula works In the example shown, the formula in B6 is: =start-CHOOSE(WEEKDAY(start),0,1,2,3,4,5,6) where “start” is the named …

Continue Reading

Display Date is same month in Excel

by

This tutorial show how to Display Date is same month in Excel using the example below. To test two dates to see they both have the same month, you can do so with a simple formula that uses the MONTH function.  Formula =MONTH(date1)=MONTH(date2) Explanation of how this formula works In the example shown, the formula in …

Continue Reading

Check If Two Dates are same month in Excel

by

This tutorial shows how to compare dates in Excel. To test two dates to see they both have the same month, you can do so with a simple formula that uses the MONTH function. Formula =MONTH(date1)=MONTH(date2) Explanation In the example shown, the formula in cell D6 is: =MONTH(B6)=MONTH(C6) How the formula works In this case, …

Continue Reading

Get month from date in Excel

by

If you need to extract the month from a date, you can use the MONTH function. Note: The date in the  formula below must be in a form that Excel recognizes as a valid date.  Formula =MONTH(date) Explanation The MONTH function takes just one argument, the date from which you want to extract the month. …

Continue Reading

Get fiscal year from date in Excel

by

To get a fiscal year from a date, you can use a formula based on the YEAR and MONTH functions. Formula =YEAR(date)+(MONTH(date)>=startmonth) Explanation In the example shown, the formula in D5 is: =YEAR(B5)+(MONTH(B5)>=C5) How this formula works By convention a fiscal year is denoted by the year in which it ends. So, if a fiscal …

Continue Reading

Get fiscal quarter from date in Excel

by

This tutorial show how to Get fiscal quarter from date in Excel. If you want to calculate the fiscal quarter from a date, and the fiscal quarter starts in a month other than January, you can use a formula based on the CHOOSE function. Formula =CHOOSE(MONTH(date),1,1,1,2,2,2,3,3,3,4,4,4) > Explanation Note: if you just need to calculate a …

Continue Reading

Sum by month ignore year in Excel

by

This tutorial shows how to Sum by month ignore year in Excel using the example below; Formula =SUMPRODUCT((MONTH(dates)=month)*amounts) Explanation To sum data by month, ignoring year, you can use a formula based on the SUMPRODUCT and MONTH functions. In the example shown, the formula in H6 is: =SUMPRODUCT((MONTH(dates)=3)*amounts) The result is a total of all …

Continue Reading

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 …

Continue Reading

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

Logical Functions

  • How to use Excel OR Function
  • Extract multiple matches into separate rows in Excel
  • How to use Excel AND Function
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • NOT function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Calculate series of dates by workdays in Excel
  • Convert text timestamp into time in Excel
  • DATEDIF function: Description, Usage, Syntax, Examples and Explanation
  • How to get workdays between dates in Excel
  • Sum through n months in Excel

Grouping

  • Group arbitrary text values in Excel
  • Group times into unequal buckets in Excel
  • How to randomly assign data to groups in Excel
  • Group times into 3 hour buckets in Excel
  • Calculate conditional mode with criteria in Excel

General

  • Freeze and Unfreeze Panes in Excel
  • How to calculate percent change in Excel
  • Flash Fill in Excel
  • How to calculate total from percentage in Excel
  • How to calculate percent of goal in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning