Need group by and difference

Hi Team,

I have some common name and some different dates against those name. So I want to group by names and want to know the difference from Max date to Min date of the dates "in days" for each names. Please find example below

Name Date Result

NNn 07/Jul/ 2023 129

nnn 06/Mar/2023 129

NNN 28/Feb/2023 129

NnN 05/Jul/ 2023 129

So here Max date is 07/Jul/2023 and Min date is 28/Feb/2023 so the difference should be 129 days

Appreciate your quick response.

Difference.xlsx

Date Time

Accepted answers

ed_hayter

So I made a new column with the names standardized for grouping then joined back to the original keeping the original names and adding the date diff on to each row.

Datediff FLow.yxzp

All comments

ed_hayter

Seperate paths to parse different date structure. Summarize to find min and max for each name then formula to calculate the difference

Edit: Alternatively could parse the different dates in a formula tool with conditional logic

Datediff FLow.yxzp

mmustkee

Hi @ed_hayter

Thanks for your response.

If you see below name which is coming for times but case is upper or lower but the name is the same.

An	7/25/2023
an	7/25/2023
AN	7/5/2023
aN	7/5/2023

We should have difference of 20 here but result shows '0' also please make sure that original values should not be lost. We should have difference for each row. for above all four names should have difference of 20.

Thanks for your help.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335