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
Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Similar threads
- Question
- Replies
- 2
- Views
- 610
- Replies
- 1
- Views
- 366
- Replies
- 0
- Views
- 160
