C H A P T E R  12

Time & Date Functions

We all know what dates are and what we mean when we say “I need it done in three days,” but such natural expressions are not so easy for computers. Unfortunately, computations that involve time and dates are essential in business and cannot be ignored. Without them it would be very difficult to judge the potential profitability of a planned business venture, the real cost of a loan, or the future value of an investment.

A lot of financial functions greatly benefit from the use of date functions, because they make it possible to automate a lot of time-based calculations. Automating things is always a good idea, because it saves you time and money.

There are two kinds of OpenOffice.org Calc time-related ...

Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.