Web Ben's Questions and Answers

Friday, September 29, 2006

OpenOffice Calculate Days Between

Someone asked me how they could calculate the number of days between two dates using OpenOffice's Spreadsheet application, Calc.

The answer is to use the "DAYS" function.

Type a date in cell A1, set the format of the cell to be a date, type another date in cell B1, set that cells format to also be a date, then enter the following in cell C1:


Cell C1 will now contain a number signifying the number of days between the two dates.

If you have any comments please let me know and if you have any other questions which you'd like me to answer for free please send them to Ben Dash at


Post a Comment

<< Home