Home/ Questions/Q 4993
Next
Answered
computing
  • 4
Asked: 2021-11-12T08:34:49+00:00 In:

IF Statement In Excel Using Today’s Date

  • 4

I am looking to make an IF statement for the following:

In cell J1 there is a date in it and I want I1 to read “Calibration Due” if the date in column J is less than or equal to 45 days from today’s date, and remain blank if this is not true.

Any help would be great!

Thanks!

Share

    1 Answer

    1. Best Answer
      Just had to change it to a less than sign

      OOPS, sorry ’bout that.

      Originally used this formula:

      =IF(TODAY()>=(J1+45),”calibrate”,””)

      When I changed it around, forgot to change the logic.

      Glad you caught it.

      MIKE

      http://www.skeptic.com/

      • 0