how to confirm if the date sequence is correct

[usyusy]

For every employee's work history, i need to confirm if the date sequence is correct. Any guidance please. A sample is given below:

Staff ID	Company	From	To
14984​	Shiny Enterprises (Pvt) Ltd	14/01/2005​	11/02/2006​
15023​	Allied Construction Pvt. Ltd.	01/04/2007​	31/12/2009​
15023​	IBM	01/08/2002​	30/03/2007​
15023​	Telecommunication Company Limited.	01/01/2001​	30/09/2002​
15026​	Style Pvt. Limited	08/09/2006​	10/04/2011​
15026​	Buff Ltd.	07/03/20003​	07/08/2006​

 

[Zot]

Please verify what you meant by date sequence.
whatever you key in into any cell, you workbook will assume the date format is similar to what you set for your computer. If your computer is d/mm/yyyy and you enter 4/12/2020, then it will become General format, not date format; if this is what you meant

 

[usyusy]

thanks sir for your reply, actually i want to make sure that the each employee has worked in any organization without overlapping the time period. So for each organization the time slab or tenure (employment period) generally should be different from other organization. If you requre any further query, please proceed.

 

[Zot]

thanks sir for your reply, actually i want to make sure that the each employee has worked in any organization without overlapping the time period. So for each organization the time slab or tenure (employment period) generally should be different from other organization. If you requre any further query, please proceed.

Sorry for late reply. There is a site which looks like related to your requirement

How to find overlapping date/time ranges in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com