IF and AND formulas
Hi,
What would be the formula to achieve the following:
if the date in “Cell A” is in the next 30 days, input “expiring in 30 days” in “Cell B”
Thanks
Best Answer
-
=IF(AND([Cell A]@row >= TODAY(), [Cell A]@row <= TODAY(30)), "Expiring in 30 days", "")
You'll want to finish that formula though with other conditions where the "" at the end is by adding additional IF formulas for other outputs it should list for date ranges.
Answers
-
=IF(AND([Cell A]@row >= TODAY(), [Cell A]@row <= TODAY(30)), "Expiring in 30 days", "")
You'll want to finish that formula though with other conditions where the "" at the end is by adding additional IF formulas for other outputs it should list for date ranges.
-
Try below in your Cell B,
=IF(AND(([Cell A]@row - TODAY()) >= 1, ([Cell A]@row - TODAY()) <= 30), "Expiring in 30-days", "Either Expired or Not Due in next 30-days")
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives