User Profile
JacquelynAbbott
Copper Contributor
Joined 4 months ago
User Widgets
Recent Discussions
Can excel assess if two dates are continuous and then run a formula based on this?
Hi all I have a spreadsheet that I use to calculate career disruptions. A disruption is deemed eligible if it is >=90 days, and ineligible if <90 days. Each period of disruption is calculated in separate rows, and the total days of disruption (column J) is calculated using the Full Time Equivalent missed multiplied by the time period of disruption [=(H16-G16)*E16]. I am wondering if there is any formula to be able to assess if the start date of one row (e.g., G17) is continuous with the end date of the previous row (e.g., H16) and if yes, to then add up the total days of the continuous time period of disruption? In my example below, rows 16-18 are not eligible to be counted as a disruption as they are all individually <90 days. But the three periods of disruption are continuous, and added together would be >90 days and therefore eligible. This is a template that is filled in by our external stakeholders, so i am trying to utilize formulas and automation as much as possible Let me know if my query is not clear/if further info is required. Thanks for any help! Jacqui
