pivot table

[ajm]

Hi, I am using a pivot table to display current lease expiry dates. I have run into a little problem relating to Extensions. A lease may have been extended so will have both an expiry date and possibly also an extension date. how do I capture the maximum of the two dates?

 

[ajm]

bump

 

[ajm]

bump

change of tack. MODS - this post can be deleted if you like. I am going to post a new question asking about dates in pivot tables.