1/1/2001
|
1/1/2003
|
=DATEDIF(Start_date,End_date,"Y")
|
Two complete
years in the period (2)
|
6/1/2001
|
8/15/2002
|
=DATEDIF(Start_date,End_date,"D")
|
440 days between
June 1, 2001, and August 15, 2002 (440)
|
6/1/2001
|
8/15/2002
|
=DATEDIF(Start_date,End_date,"YD")
|
75 days between
June 1 and August 15, ignoring the years of the dates (75)
|