How to check whether date in excel cell has been more than 60 days?

Hi,

The attached workflow accepts a date as an argument and returns a text as an output.
For test purpose the input argument is set with default value as “01/01/2019” and the workflow returns the result “earlier than two months ago”. This is not a complete solution but it will provide you with an overall concept of date comparison. For a robust solution you need to take several possible exception into account. For example first try to parse the input argument to check whether the format is correct or not…
DateComparator.xaml (8.6 KB)

Regards

1 Like