Please find the attaced excel for data .
My Requirement is - I have to check for the Statement Date and Period Type.
In the excel , we have to check the Statement Date ,
My Period Type should be 'Year End'
Here the Year 2002, 2004 is missing . and i should similarly find the years missing and if the date difference between the missed year is >= 730 days , i should display the values..
How it can be achieved?