Use function Date Difference - DATEDIF(cell1,cell2,"D") Cells 1 & 2 have your dates in then. The "D" is for days but you can use M or months etc.