IF and AND formulas

Options

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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

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

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @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
    Sameer Karkhanis ✭✭✭✭✭✭
    Options

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