• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Returning records with both date and text criteria

CNC_Monkey

New Member
Hello All,

I would like to return the information from the "COMPLETE MILESTONE LIST" tab to the "NEXT 60 DAYS" tab that occurs within the next 60 days while filtering out anything that is marked "COMPLETE" or "UNKNOWN in the STATUS column.

For extra credit: I would love to have the information sorted by date ascending based on the "DATE" column, unless there is a date in the "ETA" column, then sort the data based on the date in the "ETA" column instead of the date in the "DATE" column.

Any help is greatly appreciated!
 

Attachments

  • testing.xlsm
    28.8 KB · Views: 3
Back
Top