Hello,

I am trying to create a function that will allow me to identify the start and end date of a particular project. The file is attached bellow. Each project contains a time line marked by 1s. I am looking for a formula that will allow me to determine the start and end date of each project based on these 1s. A "1" indicates the project is being worked on. When there are no ones, then the project is either complete or hasn't started. There's an example on the first row in the file attached.

Thanks you so much for the help,and please feel free to commend or suggest any alternative ways.

Thanks!!

-Greg

Hi,

Am Wed, 12 Jun 2013 22:56:08 +0100 schrieb arceaf:

I am trying to create a function that will allow me to identify the
start and end date of a particular project. The file is attached bellow.
Each project contains a time line marked by 1s. I am looking for a
formula that will allow me to determine the start and end date of each
project based on these 1s. A "1" indicates the project is being worked
on. When there are no ones, then the project is either complete or
hasn't started. There's an example on the first row in the file
attached.

for Start Date in B2:
=MIN(IF(D2:L2=1,$D$1:$L$1))
for End Date in C2:
=MAX(IF(D2:L2=1,$D$1:$L$1))
and enter both array formulas with CTRL+Shift+Enter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2