Need to Filter out the date

Question

Hi,

I want to filter out the date which have two or more consecutive following date  in next row like:-

9/9/2022

9/10/2022

9/11/2022

I know we can use multi row formula tool to create some flag and use that column to filter out.

But I am not able to build the formula for Multi row tool.

Thank you in advance.

Sample Holiday Calendar.xlsx

DenisZ · Accepted Answer

Please see if this solves your issue

Please mark as solved if it solves the issue.

ShankerV · Accepted Answer

Hi @sgaryali

Could you please me the possible inputs and expected output.

So that can work on the solution as I was not able to get the complete information from the question.

Many thanks

Shanker V

binu_acs · Accepted Answer

@sgaryali One way of doing this with the multirow formula by taking the DayTimeDifference of the two rows