Compare the date and number of days between two dates

[alex1368]

I have an Excel file in the following example:
1- I want to check the date of the first and last communication based on two fields of a table and display it for me in one column. It means to record the first and last date based on the two fields name and number.
2- Calculate and display the number of days between two dates.
My sample file

[marzukim]

hi @alex1368
see if this approach accomplishes your expectations.

KNIME_day-diff-MM.knwf (91.1 KB)
rgds.

[tqAkshay95]

"Hello @alex1368,

you can design a workflow similar to the attached and configure it with the help of the reference also attached