# Find the corresponding date of first cell with a number

I am trying to create a resource/capacity planner that allows me to play around with when team members are assigned to the project.

I want to be able to add in a number on the days they are assigned to the project (for example 0.5 for half a day, 1 for a full day).

I need the sheet to calculate the start date of a task based on the first cell that has a numerical value.

I don't know how to make the formula reference the corresponding date in the same column.

The current formula I am using is:

=IF(ISNUMBER(INDEX(E9:FE9,MATCH(TRUE,INDEX((E9:FE9<>0),0),0))),E\$8, "Not Planned")

Right now, the first part of my formula manages to react to the first number in the row.

I need it to then recognize which column the first number belongs to and reference the corresponding date on row 8.

A copy of the sheet can be found here: EXAMPLE SHEET

Any help is much appreciated!

Thanks!

• can you share a copy/dummy of your sheet? – user0 Feb 20 at 12:40
• Hi Romi, it looks like the remainder of your title got cut off. Could you make an edit, please? – jonsca Feb 21 at 3:05
`=IF(LEN(A9),IFERROR(\$B\$2-1+MATCH(FILTER(E9:9,ISNUMBER(E9:9)),E9:9,0),"Not Planned"),"")`