Date checkbox formula

Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date.

So basically the test date less 365 days, and then checking if that date is within the current month (for example June 2017) it would be ticked.

I know I could introduce another column which takes the test date less 365 days, then the checkbox checks that column, but i'd rather not introduce yet another column.

Any ideas please???

Find more posts tagged with

Manufacturing

Formulas

Project Management

Comments

Shaine Greenwood

Hello—

I'm not exactly sure what you're wanting with the less 365 days part, are you just wanting to see if your test date is within the current month and current year?

If that's the case, you might try placing a formula like the following in a checkbox column:

=IF(AND(MONTH([Start Date]13) = MONTH(TODAY()), YEAR([Start Date]13) = YEAR(TODAY())), 1)

Make sure to change the cell references to match the columns/rows in your own sheet. You're welcome to check out our functions list here: https://help.smartsheet.com/functions

Let me know if that's not what you're wanting and maybe I can come up with another formula.