hi,

To add to Vandanavai's answer, Chip's below page provides an explanation & further examples of the DateDif function: http://www.cpearson.com/excel/datedif.aspx

hth
Rob