Hello Experts,
Want to compare todays date with data store in column, if calculated value is (negative) – it should display result as “0”, if result is (positive) + will show as “1”. Hoping I brief correctly. Still attaching sample file for your
A Column B Column
Row 1 30-09-17 ,=B3-(TODAY()) as this result is - 356, need formula and result will show as 0
Row 2 30-09-18 ,=B4-(TODAY()) as this result is + 9, need formula and result will show as 1
Thanks in Advance
ExcelUser
Have not looked at your file, but try something like this...
=if(iserror(B3-(TODAY()),0,1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try
B2Formula:
Please Login or Register to view this content.
Last edited by shukla.ankur281190; 09-21-2018 at 03:52 AM. Reason: Added cell refernce
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thanks FDibbins and Shukla for your prompt help.
FDibbins suggested formula having some error of too many argument for this function.
formula suggested by Shukla is running fine.
thanks a lot for your suggestions
Thanks for feedback. Please add reputation by clicking star icon left corner on your screen on those post which helps you.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Im happy you got the answer you needed, but Im puzzled - I tested it before posting, can you show me what the formula looked like when you used it (mine)?Originally Posted by ExcelUser2707
Thatnks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks