Sep 25 2024 12:17 PM
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
Sep 25 2024 12:21 PM
SolutionSep 25 2024 12:35 PM
Sep 30 2024 12:38 PM
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
Oct 01 2024 01:36 PM
Oct 01 2024 03:46 PM
Sep 25 2024 12:21 PM
Solution