# DATEDIF function

Returns the number of years, months, or days between two dates.

## Syntax

DATEDIF (`start date`, `end
date`, `format`)

Computes the difference
between `start date` and `end date` in
the unit specified in `format`, a code that you enter
as text.

Format | Unit returned |
---|---|

Y | Years |

M | Months |

D | Days |

MD | Days, ignoring months and years |

YM | Months, ignoring years |

YD | Days, ignoring years |

## Example

`=DATEDIF("2009-2-1","2010-3-1","YD")` returns `29`.

`=DATEDIF("2010-2-2","2010-3-1","YD")` returns `28`.