Prev Contract year

[rajni_batra]

Hello ,

I have attached a dummy file to explain my problem, In sheet one there is a contract with given Valid from valid to date

and in sheet 2 there is year on year variance for same contracts,

In sheet 3 i have mentioned the output desired.

i.e. every contract falls under 1 contract Year depending upon its valid from valid to date. But now user wants data of previous contract yr in the same line of current contract year.

Any help would be appreciated!!! thanks

Regards,

Rajni

[Gysbert_Wassenaar · Accepted solution]

See attached example