checkbox formula for last 30 days

sahilhq

Hi,

I have a date column which lists down all the dates in the year and a checkbox formula. In the checkbox column, I would like to insert a formula that would perform the following function for me:

If the date in the date column (row@cell) is in the last 30 days then checkbox.

Paul Newcome

@95766 Try something like this:

=IF(AND([Date Column]@row >= TODAY(), [Date Column]@row <= TODAY(30)), 1)

Paul Newcome

Try something along the lines of...

=IF(AND([Date Column]@row >= TODAY(-30), [Date Column]@row <= TODAY()), 1)

This is assuming there will be dates that are also in the future.

If ALL dates are in the past and you want to just grab the past 30 days, you could remove the AND and the second argument.

=IF([Date Column]@row >= TODAY(-30), 1)

sahilhq

@Paul Newcome That worked like a charm. Thank you as always!

Paul Newcome

Happy to help. 👍️

95766

I need the opposite.... Check the box IF the date is WITHIN the next 30 days. I can't seem to reverse engineer the formula.

Paul Newcome

@95766 Try something like this:

=IF(AND([Date Column]@row >= TODAY(), [Date Column]@row <= TODAY(30)), 1)

95766

@Paul Newcome Thank you!!!!!

Paul Newcome

Happy to help. 👍️