Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

Constructing Complex Formulas

The Function Wizard can be used to build some really complex formulas. Try this exercise to see what it can do. We are going to create a function that reads the current date (year, month, day), adds one to the year number, and returns the day of the week for that future date:

Figure 3-3. When you want to use another function as an argument, place the text cursor inside the original function's parentheses and choose the new function from the list.

1. Open the OpenOffice.org Calc Function Wizard.
2. Select Date&Time from the Category list.
3. Double-click the WEEKDAY function on the Function list. The right-hand side panel ...