# Date

## How to create a sequence of dates in Excel and auto fill date series

Until recently, there has been just one easy way to generate dates in Excel - the AutoFill feature. The introduction of the new dynamic array SEQUENCE function has made it possible to make a series of dates with a formula too. This tutorial takes an in-depth look at both methods so that you can choose the one that works best for you. Continue reading

## How to sort by date in Excel: in chronological order, by month, auto sort

Excel's built-in sort options are powerful and effective tools, but they do not always work correctly when it comes to sorting dates. This tutorial will teach you a few useful tricks to arrange Excel spreadsheets by date in a meaningful way without messing up your data. Continue reading

## How to calculate days since or until date in Excel

Are you stuck with calculating how many days there are since a certain date or until date? This tutorial will teach you an easy way to add and subtract days from date in Excel. With our formulas you can quickly calculate 90 days from date, 45 days before date, and count whatever number of days you need. Continue reading

## Calculate and highlight 90/60/30 days from or before today in Excel

Are you looking to calculate the expiration date that is exactly 90 days from now? Or you need to know the date that occurred 60 days before today? Whatever your task is, this tutorial will teach you how to make your own date calculator in Excel in under 5 minutes. Continue reading

## How to calculate days between dates in Excel

Are you wondering how many days are between two dates? Maybe, you need to know the number of days between today and some specific date in the past or future? Or, you just want to count working days between two dates? Whatever your task is, one of the below examples will certainly provide the solution. Continue reading

## Video: Excel date formulas made easy

This video will show you how to get Excel date formulas of any complexity without actually writing them. Learn how you can find the number of days between two dates, calculate age, add and subtract dates in Excel with your personal date&time formula assistant. Continue reading

## Excel TODAY function to insert today's date and more

You want to put today's date in some cell? Or you wish to highlight the current date in your Excel calendar? Or you'd like to find the date closest to today? All this can be done by using the Excel TODAY function and this tutorial will teach you how. Continue reading

## How to calculate age in Excel: from date of birth, between two dates

There is no special function to calculate age in Excel, however there exist a few different ways to convert date of birth to age. This tutorial will explain the advantages and drawbacks of each way, shows how make a perfect age calculation formula in Excel and tweak it for solving some specific tasks. Continue reading

## How to create calendar in Excel (drop-down and printable)

The tutorial shows how to insert a drop-down calendar in Excel, and how to quickly create a printable calendar based on a template. Continue reading

## Excel date functions - formula examples of DATE, TODAY, etc.

This is the final part of our Excel Date Tutorial that offers an overview of all Excel date functions, explains their basic uses and provides lots of formula examples. Continue reading

## Using DATE function in Excel - formula examples to calculate dates

The tutorial explains the syntax and uses of the Excel DATE function and provides formula examples for calculating dates. Continue reading

## Excel DATEDIF - calculate difference between two dates in days, weeks, months or years

In this tutorial, you will find a simple explanation of the Excel DATEDIF function and a few formula examples that demonstrate how to compare dates and calculate the difference in days, weeks, months or years. Continue reading

## How to add and subtract dates, days, weeks, months and years in Excel

In this tutorial, you will find a variety of useful formulas to add and subtract dates in Excel, such as subtracting two dates, adding days, months and years to a date, and more. Continue reading

## How to convert date to year in Excel & calculate age from date of birth

This tutorial explains the syntax and uses of the Excel YEAR function and provides formula examples to extract year from date, convert date to month and year, calculate age from the date of birth and determine leap years. Continue reading

## Calculating week number in Excel (WEEKNUM function)

In this short tutorial, we will briefly talk about the syntax and arguments of Excel WEEKNUM, and then discuss a few formula examples demonstrating how you can use the WEEKNUM function to calculate week numbers in your Excel worksheets. Continue reading

## Using MONTH and EOMONTH functions in Excel - formula examples

The tutorial explains the nuts and bolts of Excel MONTH and EOMONTH functions. You will find an array of formula examples demonstrating how to extract month from date in Excel, get the first and last day of the month, convert month name to number and more. Continue reading

## WEEKDAY, DAY and other functions to calculate days in Excel

In this tutorial, you will find lots of formula examples demonstrating the use of WEEKDAY, DAY and DAYS functions in Excel. See how to return a day of week from date, get the number of days in the year, find how many days are between two dates and more. Continue reading

## How to convert date to text in Excel with TEXT function and without formulas

The article explains how to use the Excel TEXT function and a variety of other ways to convert dates to text in Excel. Continue reading

## How to convert text to date and number to date in Excel

The tutorial explains how to use Excel functions to convert text to date and how to turn text strings into dates in a non-formula way. You will also learn how to quickly change a number to date format. Continue reading

## How to insert dates in Excel - add today's date, auto fill a column with dates

This tutorial demonstrates various ways of entering dates in Excel. See how to insert today's date and current time as static or dynamic values, how to auto populate a column or row with weekdays, and how to auto fill random dates in Excel. Continue reading

War in Ukraine! To support Ukraine and save lives please visit this page.