How to track dates 14 days and older and 30 days and older in Google Sheets

I have a google sheet that has dates that represent when I client was asked to send a document. i want to set up a way to see it these dates are 14 days or older or if they are 30 days or older. can anyone help

You can use the built-in function parseDate to convert the date-like strings into date variables first, before comparing it to (now - 14) days

e.g.:

{{ parseDate(1.date; "date format goes here") > addDays(now; -14) }}

For more information, see the function documentation in the Help Center.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

Help Center Basics

Articles & Videos

samliewrequest private consultation

Join the unofficial Make Discord server to chat with other makers!

1 Like