Hello,
I tracker the number of units sold by my sales personnel. I need to track how many days since the last unit was sold. for example:
(see attachment) if a unit was sold on monday then wednesday and today is the following monday, the answer should be two. it's been two days (business days) since they sold a unit. also, if they were to sell a unit on friday, it should automatically change to zero. can anyone help?
-rara
Last edited by rara718; 04-29-2009 at 01:23 PM. Reason: data not appearing correctly
tRY:
=5-IF(COUNT(B2:F2),MATCH(9.999999E+307,B2:F2),0)
Copied down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
so far so good. quick question. should i increase the first number in the formula ("5" in this example) depending on the number of days I'm counting?
also, would i have to change the formula each day if i wanted a updated amount each day?
I guess so.. the 5 just came from you have 5 possible cells in the row that can be filled in...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks