Spreadsheet: 887924d1738243224-start-date-and-left-date-of-employees-start-date-and-left-date
Sheet: Sheet1

I kindly request an Excel formula that compares the Date column and the Name column. The first
occurrence of a name should be identified as the START DATE, and the last occurrence should be the
DATE LEFT. Additionally, I need a formula to calculate the Number of months in the organization in
column E.
Date | Employee | Start Date | Left Date | Number of Months
2024-01-31 00:00:00 | DAS JOE
2024-01-31 00:00:00 | NOB SEITH
2024-01-31 00:00:00 | NAT JILL
2024-01-31 00:00:00 | CEKYU POU
2024-01-31 00:00:00 | [NAME]
2024-01-31 00:00:00 | NOLE QWR
2024-01-31 00:00:00 | SISTER ASF
2024-01-31 00:00:00 | [NAME]
2024-02-28 00:00:00 | DAS JOE
2024-02-28 00:00:00 | NOB SEITH
2024-02-28 00:00:00 | NAT JILL
2024-02-28 00:00:00 | CEKYU POU
2024-02-28 00:00:00 | [NAME]
2024-02-28 00:00:00 | NOLE QWR
2024-02-28 00:00:00 | SISTER ASF
2024-02-28 00:00:00 | [NAME]
2024-02-28 00:00:00 | LARTIA UYTR
2024-03-28 00:00:00 | DAS JOE
2024-03-28 00:00:00 | NOB SEITH
2024-03-28 00:00:00 | NAT JILL
2024-03-28 00:00:00 | CEKYU POU
2024-03-28 00:00:00 | [NAME]
2024-03-28 00:00:00 | NOLE QWR
2024-03-28 00:00:00 | SISTER ASF
2024-03-28 00:00:00 | [NAME]
2024-03-28 00:00:00 | LARTIA UYTR
2024-04-30 00:00:00 | DAS JOE
2024-04-30 00:00:00 | NOB SEITH
2024-04-30 00:00:00 | NAT JILL
2024-04-30 00:00:00 | [NAME]
2024-04-30 00:00:00 | NOLE QWR
2024-04-30 00:00:00 | SISTER ASF
2024-04-30 00:00:00 | [NAME]
2024-04-30 00:00:00 | LARTIA UYTR
2024-05-31 00:00:00 | DAS JOE
2024-05-31 00:00:00 | NOB SEITH
2024-05-31 00:00:00 | NAT JILL
2024-05-31 00:00:00 | [NAME]
2024-05-31 00:00:00 | NOLE QWR
2024-05-31 00:00:00 | SISTER ASF
2024-05-31 00:00:00 | [NAME]
2024-05-31 00:00:00 | LARTIA UYTR
2024-06-30 00:00:00 | DAS JOE
2024-06-30 00:00:00 | NOB SEITH
2024-06-30 00:00:00 | NAT JILL
2024-06-30 00:00:00 | [NAME]
2024-06-30 00:00:00 | NOLE QWR
2024-06-30 00:00:00 | SISTER ASF
2024-06-30 00:00:00 | [NAME]
2024-06-30 00:00:00 | LARTIA UYTR
2024-07-31 00:00:00 | DAS JOE
2024-07-31 00:00:00 | NOB SEITH
2024-07-31 00:00:00 | NAT JILL
2024-07-31 00:00:00 | [NAME]
2024-07-31 00:00:00 | NOLE QWR
2024-07-31 00:00:00 | SISTER ASF
2024-07-31 00:00:00 | [NAME]
2024-07-31 00:00:00 | LARTIA UYTR
2024-08-31 00:00:00 | DAS JOE
2024-08-31 00:00:00 | NOB SEITH
2024-08-31 00:00:00 | NAT JILL
2024-08-31 00:00:00 | [NAME]
2024-08-31 00:00:00 | NOLE QWR
2024-08-31 00:00:00 | SISTER ASF
2024-08-31 00:00:00 | [NAME]
2024-08-31 00:00:00 | LARTIA UYTR
2024-09-30 00:00:00 | DAS JOE
2024-09-30 00:00:00 | NOB SEITH
2024-09-30 00:00:00 | NAT JILL
2024-09-30 00:00:00 | [NAME]
2024-09-30 00:00:00 | NOLE QWR
2024-09-30 00:00:00 | SISTER ASF
2024-09-30 00:00:00 | [NAME]
2024-09-30 00:00:00 | LARTIA UYTR
2024-10-31 00:00:00 | DAS JOE
2024-10-31 00:00:00 | NOB SEITH
2024-10-31 00:00:00 | NAT JILL
2024-10-31 00:00:00 | [NAME]
2024-10-31 00:00:00 | NOLE QWR
2024-10-31 00:00:00 | SISTER ASF
2024-10-31 00:00:00 | [NAME]
2024-10-31 00:00:00 | LARTIA UYTR
2024-11-30 00:00:00 | DAS JOE
2024-11-30 00:00:00 | NOB SEITH
2024-11-30 00:00:00 | NAT JILL
2024-11-30 00:00:00 | [NAME]
2024-11-30 00:00:00 | NOLE QWR
2024-11-30 00:00:00 | SISTER ASF
2024-11-30 00:00:00 | [NAME]
2024-11-30 00:00:00 | LARTIA UYTR
2024-12-31 00:00:00 | DAS JOE
2024-12-31 00:00:00 | NOB SEITH
2024-12-31 00:00:00 | NAT JILL
2024-12-31 00:00:00 | [NAME]
2024-12-31 00:00:00 | NOLE QWR
2024-12-31 00:00:00 | SISTER ASF
2024-12-31 00:00:00 | [NAME]
2024-12-31 00:00:00 | LARTIA UYTR