I am trying to create a formula using an IF statement that would go of a date. If this date falls between the first half of the month (1-15) then it would calculate storage price off of one rate, and if this date falls between the second half of the month (16-30/31) then it would calculate storage price off of another rate. If this possible?

As an example, put a Date in A1 and a numerical value in B1. It will use .25 as the multiplier for Days 1-15 and .5 for 16 and beyond.

=IF(DAY(A1)<16,B1*0.25,B1*0.5)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll