BEFORE READING THIS ARTICLE , IT IS REQUESTED TO VISIT THE PART I WHICH DISCUSSES THE CONCEPT OF THE DATE AND TIME IN EXCEL FOR BETTER UNDERSTANDING.CLICK HERE TO VISIT.
DATEDIF FUNCTION CALCULATES THE NUMBER OF DAYS , MONTH OR YEARS BETWEEN THE TWO SPECIFIED DATES.
This function calculates the age if we provide it by a starting date, an
ending date and the output type[ the form in which we need the result.
It can be years, or months or days etc.]
The Syntax for the DATEDIF function in Excel is
=DATEDIF(START_DATE, END_DATE, OUTPUT_OPTION)
START_DATE is the starting date from which the counting would start or the starting date of the period. This argument needs to be given in “” or as a date number. It can also be a result of any function resulting in Date.
END_DATE is the ending date till which the counting would be done or the end date of the period. This argument should also be given in “” or as a date number.
OUTPUT_OPTION is the unit in which the result is required. Refer the following table.
Use the option as per the result required.
The type of information that you want returned, where:
The number of complete years in the period.
The number of complete months in the period.
The number of days in the period.
The difference between the days in start_date and end_date. The months and years of the dates are ignored.
This option is known to have issues which will be discussed later.
The difference between the months in start_date and end_date. The days and years of the dates are ignored
The difference between the days of start_date and end_date. The years of the dates are ignored.
Let us find out the exact age of any person in Excel.
Say, the date of birth of a person is 21-06-2000
Find his exact age today i.e. on 2-07-2020
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE