Pinterest Pixel

DATE Formula in Excel

  What does it do? Creates a date based on the year, month and day provided Formula... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

DATE Formula in Excel | MyExcelOnline DATE Formula in Excel | MyExcelOnline

 

What does it do?

Creates a date based on the year, month and day provided

Formula breakdown:

=DATE(year, month, day)

What it means:

=DATE(year of the date, month of the date, day of the date)


If you want to create dates dynamically, Excel’s DATE formula can do this for you! You just need to provide the year, month and day to it.

I explain how you can do this below:

DATE Formula in Excel | MyExcelOnline

Download excel workbookDATE-FORMULA.xlsx

STEP 1: We need to enter the DATE function in a blank cell:

=DATE(

DATE Formula in Excel

 

STEP 2: The DATE arguments:

year

What is the year of the date?

Select the cell containing the year:

=DATE(C9,

DATE Formula in Excel

month

What is the month of the date?

Select the cell containing the month:

=DATE(C9, D9,

DATE Formula in Excel

day

What is the day of the date?

Select the cell containing the day:

=DATE(C9, D9, E9)

DATE Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

See also  2 Useful Examples of IFERROR Function in Excel - A Beginner's Guide

DATE Formula in Excel

You now have your dates generated!

DATE Formula in Excel

 

How to Use the DATE Formula in Excel

 

 

DATE Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share it
DATE Formula in Excel | MyExcelOnline DATE Formula in Excel | MyExcelOnline
DATE Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...