We have a date column with dates (MM/dd/yyyy) in string format.
I have to check which all dates when substracted from todays date are multiples of 5 years i.e., even the month and days have to be taken into consideration.
I simply have to filter these dates and retrieve the employee id’s & Respective dates in table format.
PFA Excel for referenceRecords.xlsx (339.0 KB)
Hi @nikhil.girish
Could u check this workflow
data.xaml (5.8 KB)
Records.xlsx (358.6 KB)
Records — sheet 2 had output
Regards,
Nived N
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.