LinkBack URL
About LinkBacks
I cannot seem to come up with a formular that will calculate the number of days that are early or late in the format shown below.
example:
Due date Days Due
7/3/2012 -6
7/9/2012 0
7/10/2012 1
I cannot seem to come up with a formular that will calculate the number of days that are early or late in the format shown below.
example:
Due date Days Due
7/3/2012 -6
7/9/2012 0
7/10/2012 1
You get better help if you post an Excel-example of your workbook, without confidential information.
Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.
Use BEFORE/AFTER sheets if that helps make it clearer.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Sorry, I am new at this. I hope the attachement explains it better than I did? I am trying to get the speadsheet to calculate the "# of Days Due" and have it formatted the same way that it is in the spreadsheet. Any help you could give me would be appreciated!! Thank you!
Maybe like this?
I cannot believe it was that easy and I missed it. Thank you very much for your help!
Glad I could help. Thanks for the reply.
If the question is solved, will you mark your question as solved?
If you have (other) questions, just ask.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks