Some type of IF

[mantona]

Hope someone can really help with this. I have a sheet with people on it and dates they must have a sales visit.

There are the following data/columns
E - Persons Name
T - 6 week visit
U - 12 week visit
V - 16 week visit

I need a report which I can do monthly which will give:
When input a date I will get a list of all people needing a visit.

This can be one list, or can be a list of people needing 6 week visit etc.

Really needing help on this. If anyone can lend their expertise I would be very grateful.

[arthurbr]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[mantona]

Forgot to say that T, U and V are in date format.

Thanks

[mantona]

Thank you, I will do that and post back here.