How to select next service day

[BETO]

HI I have a table that has these col

DAte of service         ID.             Days

2/16/14.                     T1.             Sun Thur

2/16/14                       T2.             Sun  Wed

02/16/14.                    T3.             Sun Tue

02/16/14.                    T4.              Sun

The report is run 2 day lag so Sun report gets run on Tue .WHat report shows is day of service at ID site  Days is schedule  .

THese were all done Sun . I need to pull only the ones that have next day service that is not today() or tomorrow .

THe first one i would need is the first one and the last one.

THank for your assistance

[Reeza · Accepted solution]

Your question is difficult to understand, can you rephrase it?

[BETO]

HI Reeza,

i was having a hard time with the ask myself ...Sorry

What is being requested is a report to determine what is next day schedule. Example

Date of Service  was on Sun 2/16 I pull the report on Tue 2/17.  Because there is a lag of time between uploading data. Up to this point I have the data which looks like the table I inserted . From here they want to see only the ones base on schedule for example today is tue so if its schedule today I can exclude if its schedule for tomorrow I can exclude only the ones that are schedule later in the week are needed for the report.  Thanks Again

[BETO]

HI Reeza I figure it out  it took some outside thinking but was able to create a macro that does exactly what I need ...I'm going to close question