**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula that will allow me to calc before a certain date and after a certain date.
=if(A2<=DATE(2015,8,27),(F2*1.14),(F2*1.15))
It just multiplies column F with 1.15.
I'm assuming I need to bring in the date column into the equation?

Solved by M. Q. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
15/03/2018 - 08:08

Hello, welcome to Got It pro

User
15/03/2018 - 08:08

Hello

Excelchat Expert
15/03/2018 - 08:09

Let's try it on sheet

Excelchat Expert
15/03/2018 - 08:10

I just copy your formula

Excelchat Expert
15/03/2018 - 08:11

as you see it works here. Let's think what can be missed here

User
15/03/2018 - 08:12

Let me copy my sheet

Excelchat Expert
15/03/2018 - 08:12

1.A column must be date

User
15/03/2018 - 08:12

I copied my test table.

Excelchat Expert
15/03/2018 - 08:13

2. if you compare with F2 only you have to save its place by adding dollar sign "$F$2"

User
15/03/2018 - 08:14

Why would it not work on my sheet bybut it works here?

User
15/03/2018 - 08:14

What would my date format have to be?

Excelchat Expert
15/03/2018 - 08:16

first I check the dates with isdate() formula

Excelchat Expert
15/03/2018 - 08:16

as ypu see some aren't dates

Excelchat Expert
15/03/2018 - 08:16

let's reprint them

Excelchat Expert
15/03/2018 - 08:16

17/5/2016

Excelchat Expert
15/03/2018 - 08:19

i see its american date format here

Excelchat Expert
15/03/2018 - 08:20

first day, after that -day

User
15/03/2018 - 08:20

What format should it be for the formula to work on my sheet

Excelchat Expert
15/03/2018 - 08:21

you should your data at date column be at american date format

User
15/03/2018 - 08:22

Ok I will try that. Thank you for your help

Excelchat Expert
15/03/2018 - 08:23

the formula is OK

Excelchat Expert
15/03/2018 - 08:23

as you see i change amount to 100

Excelchat Expert
15/03/2018 - 08:23

the date after is 115

Excelchat Expert
15/03/2018 - 08:24

and before is 114

Excelchat Expert
15/03/2018 - 08:24

you also can check if date is correct by =ISDATE()

Excelchat Expert
15/03/2018 - 08:25

Thank you. Have I answered your question?

Excelchat Expert
15/03/2018 - 08:25

Thank you for using Got It and welcome again

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*