Select Page

## Function: YEAR

The Excel YEAR function returns the year from a specified date serial number. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods.Supported versionsAll Excel versionsExcel YEAR Function Syntax...

## Function: MONTH

The Excel MONTH function returns the month from a specified date serial number. In this guide, we’re going to show you how to use the this function and also throw in some tips and error handling methods.Supported versionsAll versionsExcel MONTH Function Syntax...

## Function: DAY

The DAY function in Excel returns the day from a specified date number. In this guide, we’re going to show you how to use this function and also include some tips and error handling methods.Supported versionsAll Excel versionsDAY Function in Excel Syntax...

## What week of the year is it and how to get its end date

Although Excel has a function to get week number of a date, WEEKNUM; there isn’t any to make reverse calculation. This method will help you answer the question – what week of the year is it, and give you the end date of each week. Syntax =MIN(DATE(current...

## What week of the year is it and how to get its start date

Although Excel has a function to get week number of a date, WEEKNUM; there isn’t any to make reverse calculation. This method will help you answer the question – what week of the year is it, and give you the start date of each week. Syntax...

## 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

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

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

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