If first date is in A1 and second is in A2, in A3 type the formula =A1-A2
and you will have the answer but formatted as a date, so while in the same
cell (A3) from the Format menu click on Cells and then select the Number
tab. In the box on the left select General. Answer is now a number

All the best
Philip



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