Hi ahsan. Try Chip Pearson's site: http://www.cpearson.com/excel/datedif.htm
HTH
--
Sincerely, Michael Colvin


"ahsan" wrote:

I have two dates in YYYYMMDD format in Excel. How can calculate number of
days between the two dates?