Hi. Thank you for reading and helping. I am trying to work out how to move an entire row once a particular cell is marked with an exit date.
The colums go to BK and once BK is marked with an exit date I need the data to move onto sheet "CLOSED"

Also, The data that I have on the active sheet has varios rows that contain entry date and exit date from one program to another. The formula calculates the days in each particular service but how can I get it to calculate the days a part of the service.
EG: Date into "X" = 1/1/2010 Date out of "X" 1/3/2010 = 59 days. How can I calculate days within that period eg: 2/2/2010 to 29/2/2010??

Am I confusing??