formula in excel

Firstly change the date format to dd.mm.yyyy for both the dates (in format--> Cell)

Then simply deduct the dates and change the result column into number format.. and add 1 into it to get the correct no. of days ....

Its really easy... Just put one date ni one cell e.g. 30/03/2009 in A1 cell. Then put another date in B1 cell. Then give formulla in C1 cell. Formulla = B1 - A1... You will get the answer in number fromat. If not then you can change the format of the formulla cell into number format. After that you can use the same i.e. C1 cell for your Original formulla. Ashish