Forum Discussion

itsMonty's avatar
itsMonty
Copper Contributor
Sep 25, 2024

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

 

    • itsMonty's avatar
      itsMonty
      Copper Contributor

      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

       

Resources