Forum Discussion
Is there formula to list all future dates from a column filled with past and future dates?
In col. A I have a list of dates that correspond to invoice numbers found in col. B. This puts the dates out of sequence as some of them are dates to come. Is there a formula to list just the da...
I apologize if I am not supposed to ask in this message, but it based off the same information above.
Is there a way to also sort the future dates, from the closest date to the furthest, within the same formula you provide?
=FILTER(A1:A1000, A1:A1000>TODAY(), "")
Thank you
- Thank you. So simple and effective. You would laugh at my clumsy attempts.
This works great.
Thank you kindly
