Hello,
I am using Excel 2010. My formula is comparing to dates to determine if one is greater than or equal to the other, "Yes" or "No". Excel returns "No" when the dates are equal with my formula as written here: =IF(ISBLANK(O5),"",IF(O5>=K5,"Yes","No"))
If equal to, it should be returning a "Yes" value, no?
Thank you
In a cell, any cell, enter =(O5=K5)
If it says FALSE then they are NOT equal.
What does it say?
What are the values in the date fields?
If you're still stick post the file on here and someone will spot why they are different.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I've tested your formula and it works fine, can you supply a sample sheet to show the issue?
Thanks
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
Do either of the dates (or both) also include the TIME Value ?
Try
=IF(ISBLANK(O5),"",IF(INT(O5)>=INT(K5),"Yes","No"))
Value returned was FALSE! There was a problem with transposition of number the date year. Ugh! Thank you for the quick reply and the quick test! I will use that again.
Last edited by carmiand; 07-18-2014 at 11:20 AM.
In that case your formula should work, can you post a sample pleaseOriginally Posted by carmiand
Or this
=IF(OR(K5="",O5=""),"",IF(O5>=K5,"Yes","No"))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks