“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!”
“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 will return the “Year” value from a complete Date. Output of the function will be in Numeric Year format.
“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.
“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
-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(serial_Number)
Serial_number, argument is used to give the cell address of Date from which DAY should be extracted.
“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).
=MONTH(serial_Number)
Serial_number, argument is used to give the cell address of Date from which Month should be extracted.
“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).
=YEAR(serial_Number)
Serial_number, argument is used to give the cell address of Date from which Year should be extracted.
“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).
Hope you liked. Happy Learning.
Don’t forget to leave your valuable comments!
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.
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.
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
Excel Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…
Merge Cells in Excel Merge cells is to combine multiple cells into one cell which can further be used for giving title to the report or header to the column. It helps to create clean…
MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.