Sumif ???

  • Thread starter Thread starter Sully
  • Start date Start date
S

Sully

My 1st column has dates. The 2nd column has a "status"
indicatior which is either "active" or Upgraded". What I
in the 3rd column is a date that is 180 days greater than
the date in the 1st column if the status indicator
is "active" but if the indicator is "upgraded" I want the
cell to be blank.

Thanks
 
Hi,

You can use the formula, =IF(B2="Upgraded","",A2+180)

Make sure you format the cell with the formula in the required date format.

Govind.
 
Back
Top