Forum Discussion
itsMonty
Sep 25, 2024Copper Contributor
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 dates to come in column C?
I have enclosed an image to help demonstrate
- itsMontyCopper ContributorAwesome. Thank you very much!
- itsMontyCopper Contributor
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