kerikeri
asked on
If Statement not returning expected result
This formula isn't working. It's pretty basic! Can you advise??
IfStatement.docx
IfStatement.docx
ASKER
The result I get using this formula is TRUE. See attached.
IfStatement.docx
IfStatement.docx
Why are you uploading a document instead of an Excel file?
Refer to the attached.
In the formula in AF2, replace the date format within Datevalue function if required.
DateFormula.xlsx
Refer to the attached.
In the formula in AF2, replace the date format within Datevalue function if required.
DateFormula.xlsx
ASKER
thank you. Perfect.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, I thought I had closed this already. Thanks again.
Open in new window
You may replace DATEVALUE("06/30/2016") with DATEVALUE("30/06/2016") as per your system date format.