98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel IF statements
Excel IF statements
Resolved · High Priority · Version 2007
Lisa has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Excel IF statements
Hi, having a problem with IF statements and dates
In column “D2” I have a date say 21/10/11, in column “E2” I want to return the words “Working After 24th Dec 2011 else “Left before 24th December 2011”.
I wrote the following IF statement
=IF(D2>=24/12/2011,"Working After 24th Dec 2011","Leaving Before 24th Dec 2011")
But all columns say “Working After 24th Dec 2011” even those that have an end date before 24th Dec. What have I done wrong? What should the statement be?
Thanks in advance for your help. Lisa
RE: Excel IF statements
Hi Lisa,
Thank you for your question.
Please find the following formula using the DATE function where you specify the Year, Month, Day in the Logical Test.
=IF(D1>=DATE(2011,12,24),"Working After 24th December","Leaving before 24th December")
I hope this makes sense and answers your question.
Let me know.
Regards
Simon
RE: Excel IF statements
Hi Simon, I coped your statement exactly and this statement also returns an answer of "Working After 24th December 2011" when the date in D1 is before 24th Dec.. could this be because the date in your formular is in USA format and my date is in UK format? I have tried to change the date in the formular to mirror UK date format DD/MM/YYYY but I cant work out how to do that..
RE: Excel IF statements
Hi Lisa,
Thank you for your response.
Are your dates in american or UK format?
I have attached a spreadsheet showing you my formula and the dates are in UK format. If the date is >= 24/12/2011, it returns 'Working After 24th Dec 2011'
Have a look at my spreadsheet and can you please confirm this is the result you were looking for.
Regards
Simon
Attached files...
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Screen Splitters in ExcelScreen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter. |