Not sure if this is possible.. but then again anything is possible in Excel I find from you lot...
I have a column of dates in Column C - 28/12/2018, 26/01/2019, 27/02/2019, 29/03/2019, etc...
In Cell C99 I need it to find the latest date related to the ref month number (1, 2, 3, 4, 5, etc - in cell A99) from the column range.
If that makes sense, is it possible?
I have a column of dates in Column C - 28/12/2018, 26/01/2019, 27/02/2019, 29/03/2019, etc...
In Cell C99 I need it to find the latest date related to the ref month number (1, 2, 3, 4, 5, etc - in cell A99) from the column range.
If that makes sense, is it possible?