# Date within next 90 days

Options

I am trying to create two formulas. One to flag if a date in my sheet is within the next 90 days and one to flag if a date is within the last 90 days. I have tried a couple if formulas but I can't seem to get it.... Any guidance is appreciated...

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this.

Next 90 days

```=IF(AND(Date@row >= TODAY(), Date@row <= TODAY(90)), 1)
```

Previous 90 days

```=IF(AND(Date@row >= TODAY(-90), Date@row <= TODAY()), 1)
```

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this.

Next 90 days

```=IF(AND(Date@row >= TODAY(), Date@row <= TODAY(90)), 1)
```

Previous 90 days

```=IF(AND(Date@row >= TODAY(-90), Date@row <= TODAY()), 1)
```

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!