I have a list of various clients of which each client has some of the 4 products we provide monthly service for. But each product has a different date on which we have to perform the services for the client. Think about different types of air freshener dispensers. I would like to export all the clients that are on schedule for "TODAY" in a separate column, so I may see which products and which clients we should go to.
I already used the formula to highlight TODAY's date in the various columns. But because TODAY's date can apply to various clients and various products, I cannot synchronize them because I can only sort 1 column at a time in order to see TODAY's date, otherwise, TODAY's date is scattered all over the 4 columns in different cells (which links to the client of that specific row).
Please see attached photo. Since I don't want to keep sorting the 4 different columns every time, is there a way I can insert a formula in a separate column that would refer to all the clients that I have to go to, on "TODAY's" date?
P.S. I have searched for many tutorials but just did not find the solutions for this issue. I could only find videos or sites where they show how to highlight upcoming dates etc, but this would have been easy if it was 1 product.
I would appreciate any help because we have over 80 clients and it's a lot of scrolling to find out which client's products are due.
Many thanks in advance!
Regards, Daphne