Sheets

Date diff

Example dates

Use the image above as a reference.

Get year between dates

=DATEDIF(C21;D21; "Y")

Get the months subtracting years

=DATEDIF(C23;D23; "ym")

Last updated

Was this helpful?