Calculating a change

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

is there a simple way for me to calculate the date
between a field changing ..

For example

Customer Date Sales Stage Comments
Smith 1/2/03 1 Blah Blah
2/3/03 1 Blah Blah
3/4/03 1 Blah Blah
4/5/04 2 Blah Blah


I would like to display time since last change - in other
words have a cell reading the date from 1/2/03 - 2/3/03 ,
then from 1/2/03 to 3/4/03 , then from 2/4/03 to 4/5/04..

Sorry if i have complicated a simple issue !!!

Thanks
 
Hi Graham
Not exactly sure what you want, but if you put in two
extra columns after date column and type =NOW()in one and
if Today is in A4 and original is A2, =A4-A2 in the other
Regards
Michael
 
Thanks Michael,

I was unclear , my applogies ..I was also wrong in waht i
asked for ...( having one of those days !)

I want to calculate the time that a customer is taking to
change sales stage..

I can have several entries of contact details as per
below example. In each entry will be a date and a sales
stage.

If 1st contact is date A , Customer at Sales stage A ,I
can easily display this by using =today() function and
minusing from date A.

However.. 2nd and 3rd contact the customer may remain in
Sales stage A - I would like to keep the record updating
from 1st Contact to today.

Now in contact 4 customer changes to sales stage 2 and we
start to calculate again .

Once again my applogies for being a little cloudy..

Rgds
Graham
 
Back
Top