CF_TIMEADD

The CF_TIMEADD function can be used to add or subtract a value to an existing time value.

Enter the formula =CF_TIMEADD("<time unit>",<time value>,<number>)

The following parameters need to be defined:

• A time unit within quotation marks (e.g. "ISOWEEK").
• A time value. Enter the actual time value that you want to start from or enter a cell reference to that time value.
• A number to add or subtract. For example, "1" to add one week to the start week or "-52" to subtract 52 weeks from the start week.

Example

=CF_TIMEADD("ISOYEAR",2011,-1)  will return the value 2010.

=CF_TIMEADD("ISOWEEK",201149,20) will return the value 201217.

With this function, the values in the TIMEVAL row in a template can easily be inserted with the help of one start value.

Note: The separator in the formula depends on the culture you are using in the application. "," for en-US, ";" for sv-SE, and so on.