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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Facts
Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Similar threads
- Question
- Replies
- 2
- Views
- 606
- Replies
- 1
- Views
- 199
- Replies
- 0
- Views
- 132
