I have exactly the same data I wrote in my first post, but it just keeps returning '0'. i checked the format of the cells, and these are in date format. the result column is in general format. So the format is correct, but I just dont understand why its returning '0'. I created a new workbook and tested the formula in there and it worked fine, so i dont understand why it keeps returning '0'.
My workbook is shared, but i even tired unsharing it, it the forumla didnt work, i made sure no filter was on, but still got '0'.

I really hope you can help because ive been trying to get it to work for the past 6hrs and keeping getting '0'.

appreicate your help.

thank you