I have a sheet with all my guests on it. At the moment I use a spare cell where I plug in today's date and then a nested IF statement looks at that date and compares it with the departure and arrival date in each row to determine whether or not the guests are "Future", "Current" or "Departed". If then use autofilter to show just the Current guests.

I'm wondering if there's a way using VLOOKUP or something to make this more sophisticated? Thing is, with the autofilter, I can select individual dates to know when to write goodbye letters to people etc, but I was just thinking maybe there's a more elegant solution that IFs and filters. Maybe there just isn't. Any thoughts? If not, no worries.

PM sent

Thanks Jon. Very helpful

The way I would do this is to use conditional formatting option on the cell so when the value of the cell turns to "Current", the filling of that cell (I prefer the entire row myself though) will become bright yellow or similar. So at a glance you will be able to tell what's happening.

This won't help if you have too many rows and you don't want to scroll but it seems you solved it already so I won't go into more complicated solutions. Unless you insist of course...

Nah, I'm good thanks!