Hi I need a Formula for difference in two dates for the whole column.

The first date is entered in A column and second date in B column and I need the result in C column.

There are around 1000 such entries so it goes from A1 - A1000. So, I was thinking if I can get one formula for the whole column.

ANother problem I am having is that MS Excel formulas are not working in calc..

I am working in dd/mm/yyyy format