How to create a time calculator in Excel

How to create a time calculator in Excel

When you need to calculate the difference between a time present day and the next day, calculations can get messed up and you will see lots of # characters. This article shows how to create a time calculator in Excel that can calculate shift time after midnight using...
How to calculate average by week number

How to calculate average by week number

Calculating averages by week number is a bit different than doing this by month. Instead of finding start and end dates of date range, we focus on the exact week number using the WEEKNUM function. Syntax =AVERAGEIFS( range of values to calculate average, range of week...
How to count by week number

How to count by week number

To count by week number is a bit different than by month. Instead of finding the start and end dates of the date range, we focus on exact week number using the WEEKNUM function. Syntax =COUNTIFS( range of week number helper column, current week number) Steps Add a...
How to sum by week number

How to sum by week number

To sum by week number is a bit different than How to sum by month. Instead of finding start and end dates of date range, we focus on exact week number by using WEEKNUM function. Syntax =SUMIFS( range of values to sum, range of week number helper column, current week)...
Grouping Dates in Pivot Table

Grouping Dates in Pivot Table

Excel already has functions like the SUMIF and the SUMIFS for summing data by groups. However, they won’t work when have date-time values combined. In this article we will cover grouping dates in Pivot Table. Steps Select a cell in your data Click Pivot Table...
How to create a Quarter formula in Excel

How to create a Quarter formula in Excel

There is no specific Quarter formula in Excel. But an Excel quarter formula can be constructed by combining ROUNDUP and MONTH functions with custom number formatting. Syntax =ROUNDUP( MONTH( date value ) /3, 0 ) Steps Start with =ROUNDUP( function Continue with MONTH(...
How to generate Excel month names

How to generate Excel month names

This article shows you how to generate month list by formulas and how to display Excel month names instead of actual date values. We will use DATE, YEAR and MONTH formulas as well as Number Formatting. Syntax =DATE( YEAR( previous date ), MONTH( previous date )+1, 1)...
How to count by month

How to count by month

To count by month has nothing different than How to COUNT values between two dates. However, this article shows you a more dynamic and specialized way with EOMONTH function that you don’t need to guess how many days in a month to count month. If you only want to...