Start and Finish Date

Hi, I feel that this is probably really easy but can't work it out. I have a worksheet laid out (in simple terms) as below:

Mar07 Apr07 May07 Jun07 Jul07

0 5 30 3 0

I need to write a formula that will look across the cells with the numbers and return the date of the cell with the first amount and another formula that will return the date of the cell with the last amount.

Hope you can help, Thanks for trying.

Not quite, if I use <>0 then I will get all of the months that have an amount in them. I need just the first month and just the last month. The figures represent amounts spent on a specific operation and I'm trying to identify when that operation starts and finishes.

I think the question is, in the above example, are the start and end dates Apr07 and Jun07, or are they Mar07 and Jul07?

Sorry if I'm causing confusion, I'm better with numbers than explanations and I can't get the post to lay the numbers out where I put them.

The commencement of the work is when the first cost comes in on Apr07 =5, the final month of the work is in Jun07 = 3, the months with 0 in represent months that no work was carried out.

I need the formula to look along the numbers and work out when the work started and finished.

Hope this makes more sense. Thanks

Thanks so much this is exactly what I need. Could I make another request. Could you put the formula into words so that I can understand what it is doing properly. I haven't used match and index before and I really need to understand how the formula is working so because I will be using it quite extensively.

Thanks again