LinkBack URL
About LinkBacks
hi, Please help me solve my problem about error on negative results on two dates,(#num!).
e.g start date (D2) is greater than end date(O2)
I am using this codes
=IF(D2>O2,"-"&ABS(D2-O2),DATEDIF(D2,O2,"m"))
Thanks
hi, Please help me solve my problem about error on negative results on two dates,(#num!).
e.g start date (D2) is greater than end date(O2)
I am using this codes
=IF(D2>O2,"-"&ABS(D2-O2),DATEDIF(D2,O2,"m"))
Thanks
How is it possible for something to end, before it starts?
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
#NUM! error refer to huge value and as I can see in your formula you are trying to achieve if D2 is greater than O2 then your need number of days in in negative value if the condition doesn't then how many number of month in between days.
May be this error is coming due to wrong input in D2 or O2
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)
thank you for the fast feedback Shukla.ankur281190
actually the format of the dates are in custom (ddmmyyyy) format. based on the file i'm working, i need to find the remaining terms of the account loans, yet i found errors if small amount of value are being less into huge value. so basically it should return a negative number but #num! is the one that is present in the field. and i need number of years, months , and days.
Thanks
Excel does not like working with negative dates 0 any negative dates, and will give an error, even if the difference is small
As a test, try =(today()-1)-today()
In such kind of case we must require a sample simple. Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks