A1=01-01-2007
A2=13-01-2007
A3=A2-A1 and userformat d
------ OR ---------------
A3=--TEXT(A2-A1;"d") and format as number
------ OR ----------------
DATEDIF


"Zafar" skrev:

Hi all, I would like to ask if anyone can suggest me a funtion or a formula
in Excel on how to calculate the difference between two dates in the format
of DD/MM/YYYY or similar to this, considering real number of days in a month.
The function DAYS 360 can calculate this, but only in terms of 30 days in a
month which does not answer my question.
Any help would be highly appreciated,
Thanks,
Zafar