This particular screen gives the AD assistants a quick glance at all the trips they have in the next 7 days. (8 if you include today. :)
Sort(Filter('YourSharePointList', ColumnYouWantToFilterBy.Value = "High School"And DATECOLUMN >= Today() And tripdate < DateAdd(Today(), 8, Days) ),DATECOLUMN,Ascending )
Sort(Filter('22-23-AthleticTrips', pickupbuilding.Value = "High School"And tripdate >= Today() And tripdate < DateAdd(Today(), 8, Days) ),tripdate,Ascending )