Excel Add-in for IPT

How to refer to a relative date

You can refer to a relative date by adding or substracting a number of weeks, months or years to the keywords below:

  • LASTY

  • CY

  • CWS

  • CMS

  • CYS

  • TODAY

  • YESTERDAY

Examples

LASTY-2, CY+1, CWS-2D, TODAY-1W


With CWS, CMS and CYS you can only substract (and not add) a number of weeks/months/years as these keywords refer to historical estimates.

For more information, see the Period Picker option.