SOLVED

Is there formula to list all future dates from a column filled with past and future dates?

Copper Contributor

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

itsMonty_0-1727291805914.png

 

5 Replies
best response confirmed by itsMonty (Copper Contributor)
Solution

@itsMonty 

In C1:

=FILTER(A1:A1000, A1:A1000>TODAY(), "")

@HansVogelaar 

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

 

@itsMonty 

You can use the SORT function:

=SORT(FILTER(A1:A1000, A1:A1000>TODAY(), ""))

Thank you. So simple and effective. You would laugh at my clumsy attempts.
This works great.
Thank you kindly
1 best response

Accepted Solutions
best response confirmed by itsMonty (Copper Contributor)