Running Report For Certain Days

I need to run a report where if it's Thursday then it will look for appointment dates for the following Monday, Friday will look for Tuesday, and then Monday will look for Wednesday. I found the Datepart syntax, however, I'm not sure if it should go in the Select statement area or where. The below query works but it literally looks for appointments 2 days out whether it be a weekday or weekend.

Select distinct c.ConfigECode as OfficeName,
p.PatsFirstName,
p.PatsLastName,
CONVERT(varchar(10),p.PatsBirthDate,101) as PatsBirthDate,
ins.CarrierName,
ins.CarrierPhone,
pol.PolEmployeeFirstName as EmpFirstName,
pol.PolEmployeeLastName as EmpLastName,
pol.PolEmployeeSSN,
CONVERT(varchar(10),pol.PolEmployeeBirthDate,101) as EmployeeBirthDate,
cov.GroupName,
appt.dt_appt as FutureAppt
From tPats p
Inner Join tConfig c
on c.ConfigOfficeNumber = p.OfficeNumber
Inner Join tInsurancePol pol
on pol.PolPatientID = p.PatsNumber
and pol.OfficeNumber = p.OfficeNumber
Inner Join tInsuranceCarrier ins
on ins.CarrierID = pol.PolCarrierID
Inner Join tInsCoverage cov
on cov.CoverageID = pol.PolCoverageID
Inner Join tbl_appt appt
on appt.PatsNumber = p.PatsNumber
and appt.OfficeNumber = p.OfficeNumber
Where c.ConfigOfficeNumber in ('241150','240728','240808')
and pol.PolStatus in (0,3)
and c.ConfigCenterType = 2
and CONVERT(varchar(10),appt.dt_appt,101) =
DATEADD(dd,+2,CONVERT(varchar(10),GETDATE(),101))
and appt.stat_cd = 0
Order by c.ConfigECode, p.PatsLastName, p.PatsFirstName