Thread: Status Changes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NL
 
Posts: n/a
Default Status Changes

I am trying to use one Status field married with a changing date field to
show a progression through the process any possble formulaes that might help.

Start Date 31/12/04

Status Change Date
a 01/01/05
b 01/02/05
c 01/03/05
d 01/04/05
e 01/05/05

The data collected will use a days calculation to work out average times in
process.

I just didnt want to have five collumns of visible data if not neccessary.

Thanks for all or any help.