Supposing you have two lists of dates that belong to different years and you wish to calculate the number of days between the dates as if they were of the same year. To do this, use a DATEDIF formula with "YD" unit: =DATEDIF(A2, B2, "yd") If you want the Excel DATEDIF function ...