PRVYn retrieves a value for the same day of the year from a specified variable, n years previous.

SYNTAX:

PRVYn(Cx)
where :
Cx is a conditional variable x
Exp is a Expression

NOTES:

n must be less than 100.

The year following a Leap Year will result in the Data from the 28th carrying forward to the 29th of the following year. Work around = =IF(MONTH(D)=2 AND DAY(D)=29,BLANK, PRVY1(CX))

EXAMPLES:

V306 = PRVY3(C112)

For this example, variable 306 will contain the values of variable 112 from 3 years prior to the current date.