Formula issue - IF Statement between 2 dates

Are all of the columns a Date type column? If not, you will need to reference each portion of the dates in a DATE function and compare them that way.

Because your calculations (and therefore dates) are in a text/number type column, the dates cannot be used as dates without first converting them or at least pulling specific portions from within the text string that represents the date.

The syntax for the DATE function is this:

=DATE(yyyy, mm, dd)

where you replace each portion of the function with the appropriate numerical values.

.

dmy

So to convert the text string of "30/09/2018" into a usable date, you would need to use a RIGHT function to pull the year from the string, a MID function for the month, and a LEFT function for the day, each of which will need to be wrapped in it's own VALUE function to convert the text to a numerical value that can then finally be used within the date function.

So keeping the syntax in mind, we will break it down step by step how to convert "30/09/2018" into a usable date. It really isn't as complicated as it sounds by the way.

.

To pull the year DATE(yyyy, mm, dd), we simply need 

VALUE(RIGHT([Column Name]15, 4))

We take the right 4 characters and turn them into a number with the VALUE function.

For the month DATE(yyyy, mm, dd) we use

VALUE(MID([Column Name]15, 4, 2))

We use the MID function to move into the text string to the 4th character and pull 2 characters. VALUE function to convert it into a usable number and we're done with that portion.

All that's left is the day DATE(yyyy, mm, dd)

VALUE(LEFT([Column Name]15, 2))

Left function to pull the two leftmost characters and VALUE function to convert it to a number.

.

Now we just drop each portion into the appropriate part of the DATE function, and we're done.

.

=DATE(yyyy, mm, dd)

=DATE(VALUE(RIGHT([Column Name]15, 4)), mm, dd)

.

=DATE(yyyy, mm, dd)

=DATE(VALUE(RIGHT([Column Name]15, 4)), VALUE(MID([Column Name]15, 4, 2)), dd)

.

=DATE(yyyy, mm, dd)

=DATE(VALUE(RIGHT([Column Name]15, 4)), VALUE(MID([Column Name]15, 4, 2)), VALUE(LEFT([Column Name]15, 2)))

.

Now that you have a usable date, you can drop that into a formula.

=IF([Date Column]15 = date, do this)

=IF([Date Column]15 = DATE(VALUE(RIGHT([Column Name]15, 4)), VALUE(MID([Column Name]15, 4, 2)), VALUE(LEFT([Column Name]15, 2))), do this)

Happy to help! 

Don't hesitate to ask away. There is most certainly a lot of knowledge to be found here in the Community.