# Excel - COLUMN Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.