![]() There are six different outputs that you can get from the DATEDIF function, based on what unit you use. unit: This would determine what type of result you get from this function.It can be entered as text strings in double quotes, as serial number, or as a result of some other function, such as DATE(). end_date: It’s a date that represents the end date value of the period.start_date: It’s a date that represents the starting date value of the period.=DATEDIF(start_date,end_date,unit) Input Arguments Whether it would be the number of Years, or Months, or Days is determined by the user input (see Input Arguments below). It returns a numerical value that denotes the number of Years/Months/Days between the two specified dates. A good example would be calculating the age. #3 Calculating the Number of Days Completed between two dates.Įxcel DATEDIF function can be used when you want to calculate the number of years, months, or days between the two specified dates.#2 Calculating the Number of Months Completed between two dates.#1 Calculating the Number of Years Completed between two dates.Excel DATEDIF Function (Examples + Video).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |