How to find overlapping dates

		Microsoft Office Forums > Microsoft Excel > Excel
How to find overlapping dates

FAQ

Thread Tools

Display Modes

07-30-2023, 07:23 PM

p45cal

Windows 10 How to find overlapping dates

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

Quote:

Originally Posted by p45cal

I'll have a think on it.

See attached. Same as before regarding refreshing to update the second table. Rudimentary formula in column E.

Note, in your file, in row 7 you had TIm with a capital I; my queries are case sensitive so I changed the I to an i. Instead, I can make the query case insensitive if you wish.

Attached Files

msofficeforums51161Overlapping dates request_v2.xlsx (19.8 KB, 11 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Range method Find can't find dates	jmcsa3	Excel Programming	1	05-02-2020 06:56 AM
How do you use the find and replace tool to find dates and times in Excel 2013?	Jules90	Excel	3	04-14-2020 07:40 PM
Pictures overlapping eachother on the same slide	kaiks	PowerPoint	1	11-03-2015 08:50 PM
Find and Replace: Dates	Attirb	Word	2	04-13-2011 09:56 AM
Lots of overlapping appointments!	MushyPeas	Outlook	2	01-21-2009 10:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 AM.