Home/ Questions/Q 3300
Next
In Process
Computing Staff
  • 11
Asked: 2021-11-03T12:15:26+00:00 In:

Help Writing An IF Statement Using Date Ranges

  • 11

Formula is in Cell A10
Formula needs to look at Cell W10 and if the date in W10 is between 2/12/16 and 3/20/16 then it returns “528/522”, but if the value of W10 is between 3/21/16 and 6/18/16, then it returns “567/565”, etc. I can’t figure out the syntax

Share

    1 Answer

    1. Try this and see how it works:

      =IF(AND(W10>=DATE(2016,2,12),W10<=DATE(2016,3,20)),”528/522″,IF(AND(W10>=DATE(2016,3,21),W10<=DATE(2016,6,18)),”567/565″,))

      MIKE

      http://www.skeptic.com/

      • 0