IF and AND formulas

SmartsheetRookie

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

Mike TV

@SmartsheetRookie

=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.

Mike TV

@SmartsheetRookie

=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.

Sameer Karkhanis

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")