List of Equipment Due This Week

[BobBrown60]

Hello,

I would like a list of equipment (from the Current Equipment sheet) that will be due for the week on every Monday morning. This will include the following weekend also so it will be Monday until Sunday. The due dates are in column H and the equipment numbers are in column B.

This list should have the TEL Numbers and the dates due. I would like these items to be on the Current Equipment sheet cells U11:U30 for the TEL Numbers and the dates due V11:V30.

Is this possible to do?

Thank you

[CRIMEDOG]

So U&V should match B&H?

[BobBrown60]

I only want the short list of this weeks due items please.

[BobBrown60]

This seems to be harder than I first thought maybe it isn't possible.

[AliGW]

Probably not, but the help here comes for free from volunteers in their spare time, so you may have to wait. It’s only been just over an hour - give your helper a chance!

[BobBrown60]

Oh okay sorry about that.

[CRIMEDOG]

SO I Inserted a column B -
In Column A: Check to see if the date is in the WeekNum(I used the entered date / but you can use Now()) and Year

Please Login or Register  to view this content.

In Column B: Count the Positive Results.

Please Login or Register  to view this content.

In Column V:

Please Login or Register  to view this content.

In Column W:

Please Login or Register  to view this content.

[BobBrown60]

Thanks but I don't want extra columns.

[CRIMEDOG]

you could translate the columns to X&Y. and hide the result

[BobBrown60]

Thanks for your help I will keep trying.

[BobBrown60]

Instead of having this data on the same sheet can it be put on a new sheet ?

[BobBrown60]

I figured it out thanks again for your help.