Please help calculate if date falls within a range in Excel?

[zacharie101]

<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {font-size:11.0pt; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"mm\/dd\/yy"; text-align:center; border:.5pt solid silver; white-space:normal;}.xl64 {font-size:11.0pt; font-weight:700; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:center; border:.5pt solid silver; white-space:normal;}.xl65 {font-size:11.0pt; font-weight:700; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:center; border-top:none; border-right:.5pt solid silver; border-bottom:none; border-left:.5pt solid silver; white-space:normal;}.xl66 {font-size:11.0pt; font-weight:700; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:center; border:.5pt solid silver; background:#E2EFDA; mso-pattern:black none; white-space:normal;}.xl67 {font-size:11.0pt; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"mm\/dd\/yy"; text-align:center; border:.5pt solid silver; background:#E2EFDA; mso-pattern:black none; white-space:normal;}.xl68 {font-size:11.0pt; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:center; border:.5pt solid black; background:#00B0F0; mso-pattern:black none;}--></style>

Name	From Date	To Date
A	07/30/18	08/23/18
A	06/21/18	07/30/18
B	08/01/18	08/23/18
B	06/30/18	08/01/18
C	06/25/18	07/23/18
C	07/23/18	08/21/18
C	08/09/18	08/21/18
D	06/30/18	08/09/18
E	08/02/18	08/21/18
E	06/30/18	08/02/18
F	06/11/18	06/11/18
F	08/08/18	08/21/18
F	08/08/18	08/21/18

<!--StartFragment--> <colgroup><col width="87" span="3" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

If the name of the cell matches, I want to calculate if the From and To date falls within range? Can you please help? I'm trying to make sure no date overlaps

For example, for the name "A" I want to check to see if the 2nd "A" From and To dates 6/21/18-7/30/18 falls within the dates of 7/30/18-8/23/18

 

[James006]

Hello,

In cell D3, you can test following :

=MAX(MIN(C3,C2)-MAX(B2,B6)+1,0)

HTH