Forum Discussion

itsMonty's avatar
itsMonty
Brass Contributor
Sep 25, 2024
Solved

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...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Sep 25, 2024

itsMonty 

In C1:

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

itsMonty's avatar
itsMonty
Brass Contributor
Sep 30, 2024

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

 

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 01, 2024

    itsMonty 

    You can use the SORT function:

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

    • itsMonty's avatar
      itsMonty
      Brass Contributor
      Oct 01, 2024
      Thank you. So simple and effective. You would laugh at my clumsy attempts.
      This works great.
      Thank you kindly

Resources