Change the format of the cell to Number in order to view the expected result of 8. For example, if DATEDIF(DATE(1969,7,16),DATE(1969,7,24),"D") returns, the Date format has been applied to the cell. If DATEDIF produces a result in an unexpected format, ensure that no pre-existing format has been applied to the cell. Months and years are only counted if they are equal to or go past the "day." For example, the function returns "4 months" between the dates 9/30/15 and 2/28/16 (even though the 28th is the last day of the month). "YD": the number of days between start_date and end_date, assuming start_date and end_date were no more than one year apart.
"YM": the number of whole months between start_date and end_date after subtracting whole years. "MD": the number of days between start_date and end_date after subtracting whole months. "D": the number of days between start_date and end_date. "M": the number of whole months between start_date and end_date. "Y": the number of whole years between start_date and end_date.
Unit - A text abbreviation for unit of time. Must be a reference to a cell containing a DATE, a function returning a DATE type, or a number.
Must be a reference to a cell containing a DATE, a function returning a DATE type, or a number.Įnd_date - The end date to consider in the calculation. Start_date - The start date to consider in the calculation. Calculates the number of days, months, or years between two dates.
0 kommentar(er)
