Hey guys, appreciate the help. What I need is a formula in the AG column in the Guest_Info sheet that allows for me to put in a "E". When this "E" is entered in that cell it somehow nullifies the dates that these guests stayed in this row and doesn't send them to the query. These dates are carried over to a query that I have to do a specific count on how many days each guest stays. This "E" would be used for dates that aren't counted against guests. Or I could even put this "E" in there to not count members names since they have full time access anyways. Does this make sense? Here is the workbook. Let me know if I can elaborate further. Again, thank you so much!
Bookmarks