A note about dates
Date values used as parameters for Calc's financial functions must be entered in a specific manner. For example, a date (entered in the US form), must be surrounded by quotes, and with periods separating each value. To represent August 6, 2004, or 8/6/04, you would enter, “08.06.2004â€. If you don’t enter the date values as required by the function, you will not get the correct results. Date formats are locale specific, check with your specific online help for the acceptable formatting.