zacharie101
New Member
- Joined
- Sep 13, 2015
- Messages
- 2
<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>
<!--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
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