Adding a column that nullifies cells when something is entered in it

[Chandler8]

Reference: Adding a column that nullifies cells when something is entered in it.

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!

Data.xlsm
	A	B	C	D	E	F	G	H	I	J	K						Q						W						AC	AD	AE	AF	AG	AH	AI	AJ
1	Guest Information
2
3	Check_In	Check_Out	#_of_Days	Property	Lease_Holder	Registered_Guest1	Registered_Guest2	Registered_Guest3	Registered_Guest4	Registered_Guest5	A						B						C						D	Sponsor_Last_Name	Guest_Acct_#	Comments	Exclude	#_Keys_Given	#_Keys_Returned	Key # -Notes
4	5/19/2022	5/21/2022	2	R Hart: 152 Island Drive, Unit B	Catherine Frye	Catherine Frye	Rick Jones																							Jordan	3665			2		Catherine #'s 1,2
5	5/21/2022	5/22/2022	1	Leary: 170 Loch Dornie, Unit E	Greg Proctor	Greg Proctor	Trina Proctor	Mark Poovey	Sharon Poovey																					Members				1		Greg (#1)
6	5/26/2022	5/30/2022	4	Laskin: 1236 Mountain Springs	Neal Blinde	Neal Blinde	Jessica Blinde	Arden Blinde	Norah Blinde	Graham Blinde																				Members
7	5/26/2022	5/31/2022	5	L. Hart: 934 Hillside Drive	Stacie Menichella	Stacie Menichella	Dan Menichella	Bryce Menichella	Brandon Artiqua	Lauren Artiqua																				Members				4		Stacie #'s 1,2 Dan (#3) Brandon (#4)
8	5/27/2022	5/30/2022	3	Belk: 987 Mountain Springs	Dave Powell	Dave Powell	Meredith Powell	Porter Powell	Rivers Powell	Ella Powell																				Turner	3668			2		Dave #'s 1,2
9	5/27/2022	5/30/2022	3	Young: 282 North Wildflower	David Taylor	David Taylor	Elizabeth Taylor	Broughton Taylor	William Taylor																					Members				2		David (#1) Elizabeth (#2)
10	6/1/2022	7/3/2022	32	Garrison: 248 South Wildflower	Brandon Brown	Brandon Brown	Sara Brown	Thomas Brown	William Brown																					Members				2
11	6/4/2022	6/12/2022	8	Young: 282 North Wildflower	Chris Lowe	Chris Lowe	Heather Lowe	Collis Lowe	Taylor Lowe	Laura Lowe																				Jim Wood	3666			2		Chris (#3) Heather (#4)
12	6/5/2022	6/15/2022	10	Howey: 995 Hillside Drive	Robert Maclnnis	Robert Maclnnis	Jan Maclnnis	Jay Maclnnis	Sean Maclnnis	Ray Goff																				GCP	3667	Dogs Approved		2		Robert #'s 1,2
13	6/8/2022	6/10/2022	2	Walters: 141 Lakeview, Unit A	GGCC	Craig Smith																								GGCC						Craig (#3)
14	6/9/2022	6/22/2022	13	Flowers: 276 Island Drive, Unit B	Audra Rankin	Audra Rankin	Hunter Rankin	Ellen Rankin	Addie Rankin																					John Black	3268			2		Audra #'s 1,2
15	6/10/2022	6/17/2022	7	Laskin: 1236 Mountain Springs	Stacie Menichella	Stacie Menichella	Dan Menichella	Bryce Menichella	Debra Dawson	Rick Dawson																				Members
16	6/11/2022	6/14/2022	3	Leary: 170 Loch Dornie, Unit E	Clifton Cameron	Clifton Cameron	Shannon Cameron	Keens Cameron	Lily Cameron	Holden Cameron																				Members				2		Clifton #'s 1,2
17	6/12/2022	6/15/2022	3	Walters: 141 Lakeview, Unit A	Owen Gwyn	Owen Gwyn	Darri Gwyn																							Members				2		Own #'s 1,2
18	6/17/2022	6/19/2022	2	Sewell: 210 Loch Dornie, Unit B	Michael Patton	Michael Patton	Amy Patton																							Members				2		Michael #'s 1,2
19	6/18/2022	7/1/2022	13	Laskin: 1236 Mountain Springs	Anne Warren	Anne Warren	Ellie Waren	Timothy Warren	Claire Warren	Jeff Warren																				McCavera	3670
20	6/19/2022	6/22/2022	3	Porterfield: 161 Mountain View	Patrick Walsh	Patrick Walsh	Emily Walsh	Michael Walsh	Martha Walsh	Patrick Jr. Walsh																				GGCC/Porter	3669			1		Patrick (#1)
21	6/22/2022	6/26/2022	4	Leary: 170 Loch Dornie, Unit E	Mark Frisch	Mark Frisch																								Members				1		Mark (#3)
22	6/23/2022	6/26/2022	3	Porterfield: 161 Mountain View	Anne McGowan	Cam Findlay	Amy Findlay	David Findlay	Susan Findlay	Kathryn Beiser																				Members				1
23	6/23/2022	6/30/2022	7	L Hart: 934 Hillside Drive	Hans Stig Moller	Hans Stig Moller	Nancy Stig Moller	Catherine Stig Moller	Rita Stig Moller	Jens Stig Moller																				Dalrymple	3671			3		Hans #'s 1,2,3
24	6/24/2022	7/1/2022	7	Howey: 995 Hillside Drive	Ginny Shaw	Ginny Shaw	Ruthie Shaw	Finley Shaw	Robbie Shaw	Alan Shaw																				NA	3672			2		Ginny (#3) Robbie (#4)
25	6/26/2022	6/27/2022	1	King: 141 Lakeview, Unit C	David Powell	Chip Dotson	Mike Kavanagh	John Lady																						Powell				2		John (#1) Mike (#2)
26	6/26/2022	7/1/2022	5	Young: 282 North Wildflower	Tony Simmons	John Simmons	Cathy Simons	Elliott Simmons	David Simmons	Mary Catherine Simmons																				Members				2		Cathy #'s 1,2
27	6/28/2022	7/2/2022	4	Ford: 306 Woodchuck, Unit B	Kelly Taylor	Kelly Taylow	Matt Taylor	Hank Taylor	Maggie Taylor																					Threlkeld	3673					Kelly #'s 1,2
28	6/29/2022	7/10/2022	11	Sewell: 210 Loch Dornie, Unit B	Cathy Blackwelder	Cathy Blackwelder	Emery Blackwelder	Chip Blackwelder	Alli Wengert	Ben Wengert																				Blackwelder	3525					Cathy #'s 3,4 Emery #'s 5,6
29	7/1/2022	7/5/2022	4	Young: 282 North Wildflower	Mary Johnston	Mary Johnston	Dean Johnston	Jack Johnston	Caroline Johnston	Ainsley Heffinger																				Members				2		Dean #'s 3,4
30	7/1/2022	7/6/2022	5	Walters: 141 Lakeview, Unit A	Jody Brinson	Jody Brinson	Charles Brinson																							Williams	3674			2		Jody #'s 1,2
Guest_Info

Cell Formulas
Range	Formula
C4:C30	C4	=IF(B4-A4=0,"",B4-A4)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F3:F1048576	Cell	contains a blank value	text	NO
F4:V994	Cell Value	duplicates	text	NO

Data.xlsm
	A	B	C	D	E	F
1	Guest	Last_Name	Check_In	Check_Out	Sponsor_Last_Name	Lease_Holder
2	Catherine Frye	Frye	5/19/2022	5/21/2022	Jordan	Catherine Frye
3	Rick Jones	Jones	5/19/2022	5/21/2022	Jordan	Catherine Frye
4	Greg Proctor	Proctor	5/21/2022	5/22/2022	Members	Greg Proctor
5	Trina Proctor	Proctor	5/21/2022	5/22/2022	Members	Greg Proctor
6	Mark Poovey	Poovey	5/21/2022	5/22/2022	Members	Greg Proctor
7	Sharon Poovey	Poovey	5/21/2022	5/22/2022	Members	Greg Proctor
8	Neal Blinde	Blinde	5/26/2022	5/30/2022	Members	Neal Blinde
9	Jessica Blinde	Blinde	5/26/2022	5/30/2022	Members	Neal Blinde
10	Arden Blinde	Blinde	5/26/2022	5/30/2022	Members	Neal Blinde
11	Norah Blinde	Blinde	5/26/2022	5/30/2022	Members	Neal Blinde
12	Graham Blinde	Blinde	5/26/2022	5/30/2022	Members	Neal Blinde
13	Stacie Menichella	Menichella	5/26/2022	5/31/2022	Members	Stacie Menichella
14	Dan Menichella	Menichella	5/26/2022	5/31/2022	Members	Stacie Menichella
15	Bryce Menichella	Menichella	5/26/2022	5/31/2022	Members	Stacie Menichella
16	Brandon Artiqua	Artiqua	5/26/2022	5/31/2022	Members	Stacie Menichella
17	Lauren Artiqua	Artiqua	5/26/2022	5/31/2022	Members	Stacie Menichella
18	Dave Powell	Powell	5/27/2022	5/30/2022	Turner	Dave Powell
19	Meredith Powell	Powell	5/27/2022	5/30/2022	Turner	Dave Powell
20	Porter Powell	Powell	5/27/2022	5/30/2022	Turner	Dave Powell
21	Rivers Powell	Powell	5/27/2022	5/30/2022	Turner	Dave Powell
22	Ella Powell	Powell	5/27/2022	5/30/2022	Turner	Dave Powell
23	David Taylor	Taylor	5/27/2022	5/30/2022	Members	David Taylor
24	Elizabeth Taylor	Taylor	5/27/2022	5/30/2022	Members	David Taylor
25	Broughton Taylor	Taylor	5/27/2022	5/30/2022	Members	David Taylor
26	William Taylor	Taylor	5/27/2022	5/30/2022	Members	David Taylor
27	Brandon Brown	Brown	6/1/2022	7/3/2022	Members	Brandon Brown
28	Sara Brown	Brown	6/1/2022	7/3/2022	Members	Brandon Brown
29	Thomas Brown	Brown	6/1/2022	7/3/2022	Members	Brandon Brown
30	William Brown	Brown	6/1/2022	7/3/2022	Members	Brandon Brown
31	Chris Lowe	Lowe	6/4/2022	6/12/2022	Jim Wood	Chris Lowe
32	Heather Lowe	Lowe	6/4/2022	6/12/2022	Jim Wood	Chris Lowe
33	Collis Lowe	Lowe	6/4/2022	6/12/2022	Jim Wood	Chris Lowe
34	Taylor Lowe	Lowe	6/4/2022	6/12/2022	Jim Wood	Chris Lowe
35	Laura Lowe	Lowe	6/4/2022	6/12/2022	Jim Wood	Chris Lowe
36	Robert Maclnnis	Maclnnis	6/5/2022	6/15/2022	GCP	Robert Maclnnis
37	Jan Maclnnis	Maclnnis	6/5/2022	6/15/2022	GCP	Robert Maclnnis
38	Jay Maclnnis	Maclnnis	6/5/2022	6/15/2022	GCP	Robert Maclnnis
39	Sean Maclnnis	Maclnnis	6/5/2022	6/15/2022	GCP	Robert Maclnnis
40	Ray Goff	Goff	6/5/2022	6/15/2022	GCP	Robert Maclnnis
41	Mary Harrison	Harrison	6/5/2022	6/15/2022	GCP	Robert Maclnnis
42	Craig Smith	Smith	6/8/2022	6/10/2022	GGCC	GGCC
43	Audra Rankin	Rankin	6/9/2022	6/22/2022	John Black	Audra Rankin
44	Hunter Rankin	Rankin	6/9/2022	6/22/2022	John Black	Audra Rankin
45	Ellen Rankin	Rankin	6/9/2022	6/22/2022	John Black	Audra Rankin
46	Addie Rankin	Rankin	6/9/2022	6/22/2022	John Black	Audra Rankin
47	Stacie Menichella	Menichella	6/10/2022	6/17/2022	Members	Stacie Menichella
48	Dan Menichella	Menichella	6/10/2022	6/17/2022	Members	Stacie Menichella
49	Bryce Menichella	Menichella	6/10/2022	6/17/2022	Members	Stacie Menichella
50	Debra Dawson	Dawson	6/10/2022	6/17/2022	Members	Stacie Menichella
51	Rick Dawson	Dawson	6/10/2022	6/17/2022	Members	Stacie Menichella
52	John Stewart	Stewart	6/10/2022	6/17/2022	Members	Stacie Menichella
53	Lynn Stewart	Stewart	6/10/2022	6/17/2022	Members	Stacie Menichella
54	Clifton Cameron	Cameron	6/11/2022	6/14/2022	Members	Clifton Cameron
55	Shannon Cameron	Cameron	6/11/2022	6/14/2022	Members	Clifton Cameron
56	Keens Cameron	Cameron	6/11/2022	6/14/2022	Members	Clifton Cameron
57	Lily Cameron	Cameron	6/11/2022	6/14/2022	Members	Clifton Cameron
58	Holden Cameron	Cameron	6/11/2022	6/14/2022	Members	Clifton Cameron
59	Owen Gwyn	Gwyn	6/12/2022	6/15/2022	Members	Owen Gwyn
60	Darri Gwyn	Gwyn	6/12/2022	6/15/2022	Members	Owen Gwyn
61	Michael Patton	Patton	6/17/2022	6/19/2022	Members	Michael Patton
62	Amy Patton	Patton	6/17/2022	6/19/2022	Members	Michael Patton
63	Anne Warren	Warren	6/18/2022	7/1/2022	McCavera	Anne Warren
64	Ellie Waren	Waren	6/18/2022	7/1/2022	McCavera	Anne Warren
65	Timothy Warren	Warren	6/18/2022	7/1/2022	McCavera	Anne Warren
66	Claire Warren	Warren	6/18/2022	7/1/2022	McCavera	Anne Warren
67	Jeff Warren	Warren	6/18/2022	7/1/2022	McCavera	Anne Warren
68	Grant Warren	Warren	6/18/2022	7/1/2022	McCavera	Anne Warren
69	Lydia Strunck	Strunck	6/18/2022	7/1/2022	McCavera	Anne Warren
70	Graham Strunck	Strunck	6/18/2022	7/1/2022	McCavera	Anne Warren
71	Evie Strunck	Strunck	6/18/2022	7/1/2022	McCavera	Anne Warren
72	Charlotte Strunck	Strunck	6/18/2022	7/1/2022	McCavera	Anne Warren
73	Patrick Walsh	Walsh	6/19/2022	6/22/2022	GGCC/Porter	Patrick Walsh
74	Emily Walsh	Walsh	6/19/2022	6/22/2022	GGCC/Porter	Patrick Walsh
75	Michael Walsh	Walsh	6/19/2022	6/22/2022	GGCC/Porter	Patrick Walsh
76	Martha Walsh	Walsh	6/19/2022	6/22/2022	GGCC/Porter	Patrick Walsh
77	Patrick Jr. Walsh	Jr. Walsh	6/19/2022	6/22/2022	GGCC/Porter	Patrick Walsh
78	Jenna Walsh	Walsh	6/19/2022	6/22/2022	GGCC/Porter	Patrick Walsh
79	Emma Walsh	Walsh	6/19/2022	6/22/2022	GGCC/Porter	Patrick Walsh
80	Ann Walsh	Walsh	6/19/2022	6/22/2022	GGCC/Porter	Patrick Walsh
81	Mark Frisch	Frisch	6/22/2022	6/26/2022	Members	Mark Frisch
82	Cam Findlay	Findlay	6/23/2022	6/26/2022	Members	Anne McGowan
83	Amy Findlay	Findlay	6/23/2022	6/26/2022	Members	Anne McGowan
84	David Findlay	Findlay	6/23/2022	6/26/2022	Members	Anne McGowan
85	Susan Findlay	Findlay	6/23/2022	6/26/2022	Members	Anne McGowan
86	Kathryn Beiser	Beiser	6/23/2022	6/26/2022	Members	Anne McGowan
87	Mick Domagala	Domagala	6/23/2022	6/26/2022	Members	Anne McGowan
88	Margie Bennett	Bennett	6/23/2022	6/26/2022	Members	Anne McGowan
89	Mike Bennett	Bennett	6/23/2022	6/26/2022	Members	Anne McGowan
90	Julie Kunetka	Kunetka	6/23/2022	6/26/2022	Members	Anne McGowan
91	Marjorie Newman	Newman	6/23/2022	6/26/2022	Members	Anne McGowan
92	Matthew Newman	Newman	6/23/2022	6/26/2022	Members	Anne McGowan
93	Hans Stig Moller	Stig Moller	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
94	Nancy Stig Moller	Stig Moller	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
95	Catherine Stig Moller	Stig Moller	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
96	Rita Stig Moller	Stig Moller	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
97	Jens Stig Moller	Stig Moller	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
98	Raymond Coltrain	Coltrain	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
99	Kay Coltrain	Coltrain	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
100	Tom Smith	Smith	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
101	Martha Smith	Smith	6/23/2022	6/30/2022	Dalrymple	Hans Stig Moller
102	Ginny Shaw	Shaw	6/24/2022	7/1/2022	NA	Ginny Shaw
103	Ruthie Shaw	Shaw	6/24/2022	7/1/2022	NA	Ginny Shaw
104	Finley Shaw	Shaw	6/24/2022	7/1/2022	NA	Ginny Shaw
105	Robbie Shaw	Shaw	6/24/2022	7/1/2022	NA	Ginny Shaw
106	Alan Shaw	Shaw	6/24/2022	7/1/2022	NA	Ginny Shaw
107	Mary Howard Shaw	Howard Shaw	6/24/2022	7/1/2022	NA	Ginny Shaw
108	Ashley Shaw	Shaw	6/24/2022	7/1/2022	NA	Ginny Shaw
109	Gaye Law	Law	6/24/2022	7/1/2022	NA	Ginny Shaw
110	Chip Dotson	Dotson	6/26/2022	6/27/2022	Powell	David Powell
111	Mike Kavanagh	Kavanagh	6/26/2022	6/27/2022	Powell	David Powell
112	John Lady	Lady	6/26/2022	6/27/2022	Powell	David Powell
113	John Simmons	Simmons	6/26/2022	7/1/2022	Members	Tony Simmons
114	Cathy Simons	Simons	6/26/2022	7/1/2022	Members	Tony Simmons
115	Elliott Simmons	Simmons	6/26/2022	7/1/2022	Members	Tony Simmons
116	David Simmons	Simmons	6/26/2022	7/1/2022	Members	Tony Simmons
117	Mary Catherine Simmons	Catherine Simmons	6/26/2022	7/1/2022	Members	Tony Simmons
118	Anna Grace Simmons	Grace Simmons	6/26/2022	7/1/2022	Members	Tony Simmons
119	Kelly Taylow	Taylow	6/28/2022	7/2/2022	Threlkeld	Kelly Taylor
120	Matt Taylor	Taylor	6/28/2022	7/2/2022	Threlkeld	Kelly Taylor
121	Hank Taylor	Taylor	6/28/2022	7/2/2022	Threlkeld	Kelly Taylor
122	Maggie Taylor	Taylor	6/28/2022	7/2/2022	Threlkeld	Kelly Taylor
123	Cathy Blackwelder	Blackwelder	6/29/2022	7/10/2022	Blackwelder	Cathy Blackwelder
124	Emery Blackwelder	Blackwelder	6/29/2022	7/10/2022	Blackwelder	Cathy Blackwelder
125	Chip Blackwelder	Blackwelder	6/29/2022	7/10/2022	Blackwelder	Cathy Blackwelder
126	Alli Wengert	Wengert	6/29/2022	7/10/2022	Blackwelder	Cathy Blackwelder
127	Ben Wengert	Wengert	6/29/2022	7/10/2022	Blackwelder	Cathy Blackwelder
128	Mary Johnston	Johnston	7/1/2022	7/5/2022	Members	Mary Johnston
129	Dean Johnston	Johnston	7/1/2022	7/5/2022	Members	Mary Johnston
130	Jack Johnston	Johnston	7/1/2022	7/5/2022	Members	Mary Johnston
131	Caroline Johnston	Johnston	7/1/2022	7/5/2022	Members	Mary Johnston
132	Ainsley Heffinger	Heffinger	7/1/2022	7/5/2022	Members	Mary Johnston
133	Sam Heffinger	Heffinger	7/1/2022	7/5/2022	Members	Mary Johnston
134	Jody Brinson	Brinson	7/1/2022	7/6/2022	Williams	Jody Brinson
135	Charles Brinson	Brinson	7/1/2022	7/6/2022	Williams	Jody Brinson
Query