highlight current date

[Guest]

I have a shared workbook that we schedule on, it has a 6 week set up from
week beginning Sat and Ending on Friday. Multiple people use this workbook.
The dates recycle, When we reach the end of the 6 weeks, we clear the
schedule and redo the dates for the next 6 weeks.
My question is this. Each week has a series of zipcodes associate with it,
that is how we choose to schedule things. If when we use the find function to
look for the zip code, it will pick up the first one it finds, what we'd like
it to do, is to go to zip code in the current week. How to I convince it to
go to the current week?

 

[Guest]

Consider using a helper column with something like:
=zipcode & date

When you do a find, it will pick the correct one.

 

[Guest]

Or consider organizing the wroksheet in a way you shouldn't have to use find.
For example, a table column for date and a table column for zip. Filter for
date and filter for zip.