How to find overlapping dates

p45cal · #1 07-30-2023, 06:33 AM

Quote:

Originally Posted by Agnieszka

Is there a function that will allow me to track overlapping leave requests?

1. Overlapping ignoring all names and leave types, that is any overlapping dates in the whole table? Or maybe just by Name? Or both Name and leave type?

2. When you say 'track', how do you want to see/report this tracking?

Quote:

Originally Posted by Agnieszka

My Excel doesn't have FILTER function.

What version of Excel are you using?

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