Lesson#15: Know about functions DATE, DAY, MONTH, YEAR

Lesson#15: Know about functions DATE, DAY, MONTH, YEAR

In this post, we will talk about the functions DATE, DAY, MONTH, and YEAR. DATE function converts date, month, and year values into single-line date format. Let me show you an example.

I have written DAY, MONTH, and YEAR for indicating the space for entering a value. Syntax of DATE is =DATE(year, month, day)

Then I have entered the formula =DATE(C4, C3, C2), wherein the C4 cell I will put the value for the year, in the C3 cell I will put the value for the month, and in the C2 cell I will put the value for the day,

Changed the format of the date by right-clicking on the cell like the picture above.

That is how it looks when I input values in these cells.

Now I will show the DAY, MONTH, YEAR function to extract the value of a day, month, or year from a date format.

Syntax =DAY(serial_number)
So the formula I have put =DAY(B6)

Syntax =MONTH(serial_number)
So the formula I have put =MONTH(B6)

 
 
 
 
 
 
 
 
Syntax =YEAR(serial_number)
So the formula I have put =YEAR(B6)
 
 
 
 
 
 
 
 
 
That is how it works.
You can download my excel file which is shown as an example from the given link below.
See also  Lesson#101: Hyperlink all files and folders in the worksheet within a minute

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*