Inserting Date Functions

Cette page est en cours de traduction. Elle sera mise à jour dès que son contenu sera disponible en français.

You can insert date functions into your Microsoft^® Excel^® and Microsoft^® Word workpapers using the Axcess Engagement ribbon. Adding date functions to a workpaper can reduce how often you must manually add or edit dates in your workpapers. If you roll forward a workpaper, the date functions will update automatically in the new workpaper.

Note: This feature is not yet available for consolidated engagements.

Tell me which date functions I can insert in a workpaper.

Current year Current period begin date Current period end date

Prior year (up to 5 prior years) Prior period begin date (up to 5 years prior) Prior period end date (up to 5 years prior)

Another advantage that CCH iFirm Engagement gives you is the ability to save engagements and workpapers as templates. If you link any date functions into the template workpapers or the individual workpaper templates, you can create files from those templates, and all of the date links reflect the correct information based on that engagement's period information.

Example: You saved a workpaper in an engagement where you had linked the prior period and current year-end dates as column headers. If you save that workpaper as a template and add it to a different binder, the dates automatically change to that binder's period information. You do not have to re-link these fields after inserting the workpapers into a new engagement.

To insert a date function:

1. Open the Excel^® or Word workpaper you want to add date function links to.

   1. Cliquez sur la mission dans la page Liste de missions.

      Remarque : Consultez la rubrique Utiliser la page Liste de missions pour obtenir plus de renseignements sur l'utilisation des fonctions de pagination et de recherche pour trouver une mission dans la liste.

   2. Locate the workpaper on the Engagement View page.

      Tip: You might need to expand the node or folder that holds the item you need.

2. Click the cell or location where you want to add the date function.
3. Click Date Functions on the Axcess Engagement ribbon, and then select the date function you want to add.

Important: If you have CCH iFirm Engagement installed on your computer, you may also see an Engagement ribbon. Be sure to click the button on the Axcess Engagement ribbon.

4. If prompted to do so, select additional date format options, and then click OK.