If units are other than predefined units(YM, MD,Y,M, D, YD), then in this case, the DATEDIF function will retrieve the #NUM! error. If you set the "unit" argument to "MD", then the year will extract from the "end_date". If you set the "unit" argument to "YM", then the ...