Solved If statements in excel using a date range

September 7, 2016 at 11:11:49
Specs: Windows 7
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?

See More: If statements in excel using a date range

Report •

#1
September 7, 2016 at 11:45:12
✔ Best Answer
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.


Report •
Related Solutions


Ask Question