Forum Discussion
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 i...
Here's an Excel 365 solution.
My formula uses named items:
=LET(
x, DROP(StartDate, 1),
y, DROP(EndDate, -1),
g, VSTACK(0, x) - VSTACK(0, y) = 1,
h, ABS(VSTACK(y, 0) - VSTACK(x, 0)) = 1,
d, DaysDisruption >= 90,
filtered, FILTER(DaysDisruption, g + h + d, 0),
SUM(filtered)
)
