LinkBack URL
About LinkBacks
Please see the attachment.The formula I'm using is in the formula bar in the screenshot. The circled row shows the error. Why is the IF formula not working properly when comparing these two dates?
Please see the attachment.The formula I'm using is in the formula bar in the screenshot. The circled row shows the error. Why is the IF formula not working properly when comparing these two dates?
Last edited by Snelms; 10-14-2014 at 03:49 PM.
Hi,
You didn't upload the workbook as an attachment. We prefer them to mere pictures.
Do both G& & K7 contain date numbers?
Test with =ISNUMBER(G7) & ISNUMBER(K7)
What results do you get?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I just tried the EXACT formula on a sample sat of data I created and it worked correctly.
Can you post your data so we can take a look?
Also, try:
Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I figured it out. The highlighted Column is a complicated formula with lots of nested IFs. When I hard coded that column the formula works correctly.
Thanks all!
I can't post the spreadsheet as it is sensitive data. I will also try to use the Value function mikeTRON so as to not create a duplicate hard coded cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks