Excel Function DAY, MONTH, YEAR

Complete Excel VBA Course

Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date. These functions are very helpful and while transforming the existing database and each of them has their unique characteristics.

“DAY, MONTH, YEAR Functions” has only one argument i.e. (serial_number) that makes it easy to apply. The output of the function will return the value of Day, Month or Year and incase the input is not correct then it will return the output as “#VALUE!”

“DAY FUNCTION”:

“DAY” function will return the “Day” value from a complete Date. Output of the function will be in Numeric format and would be between 1 to 31.

Complete Excel VBA Course
“MONTH FUNCTION”:

“MONTH” function will return the “Month” value from a complete Date. Output of the function will be in Numeric format and would be between 1 to 12.

“YEAR FUNCTION”:

“YEAR” function will return the “Year” value from a complete Date. Output of the function will be in Numeric Year format.

Excel Function DAY, MONTH, YEAR Advantage:-

“DAY, MONTH, YEAR Functions” can be used in any Date format, which makes the function useful and advantageous. Applying the functions manually (one by one) to insert the value is very difficult and “DAY, MONTH, YEAR Functions” helps to apply the function in large database at once and makes the work easy, saves time and increases efficiency.

Where “DAY, MONTH, YEAR Functions” can be used:

“DAY, MONTH, YEAR Functions” are very useful and can be used in many situations. Like it can be used as follows:

– Preparing and consolidation of report as per DAY, MONTH or YEAR
– Preparing Aging report and Debtor/ Creditor summary as per specific period
– Or any other database where there is requirement extracting DAY, MONTH or YEAR

Things to Remember:

-DAY, MONTH or YEAR functions returns the output in Number format but if there is any error in the input cell then it will return the output error as “#VALUE!”

-We need to ensure that the input data i.e. Date should be in correct and recognizable format for Microsoft Excel.

“DAY ” Syntax:
=DAY(serial_Number)
Syntax Description:

Serial_number, argument is used to give the cell address of Date from which DAY should be extracted.

Example 1: Explore “DAY” Function

“DAY” function will return the output from a Date. As per below example we can see that with the help of DAY function, Day is extracted i.e. 19 from date i.e. 03/19/2020 (19th March 2020).

Excel Function Day Month Year
“MONTH” Syntax:
=MONTH(serial_Number)
Syntax Description:

Serial_number, argument is used to give the cell address of Date from which Month should be extracted.

Example 2: Explore “MONTH” Function

“MONTH” function will return the output from a Date. As per below example we can see that with the help of MONTH function, MONTH is extracted i.e. 3 (March) from date i.e. 03/19/2020 (19th March 2020).

Excel Function Day Month Year
“YEAR” Syntax:
=YEAR(serial_Number)
Syntax Description:

Serial_number, argument is used to give the cell address of Date from which Year should be extracted.

Example 3: Explore “YEAR” Function

“YEAR” function will return the output from a Date. As per below example we can see that with the help of YEAR function, YEAR is extracted i.e. 2020 from date i.e. 03/19/2020 (19th March 2020).

Excel function Day Month Year

Hope you liked. Happy Learning.

Don’t forget to leave your valuable comments!

Download Practice File

You can also practice this through our practice files. Click on the below link to download the practice file.

Recommended Articles

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

Similar Posts

Leave a Reply

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