Hello, Need some help with a formula.
I have a bunch of dates in my spreadsheet, Using the max function I want to find the soonest date to now (that's easy) but actually i need the data that's 1 cell to the right of it.
I'm fairy new to excel but have tried paring a max with a offset but no joy.
Alternatively instead of showing the date of max, can the result just show which the address instead?
For example : Say I'm writing this formula in B1 =max(a1,a2,a3)
A1, June 3
A2, June 4
A3, June 5
The soonest is June 5, but the result I want to display in B1 is A3, not June 5.
Bookmarks