Can i count the number of months in a specific range

Hi Everyone..

Refer to the attached excel file,
The green line is the total sum of man-hours that Robin needed to do in a month.
If you look at the data, there are certain month where he does not require to work..

So the data that i want to count is the "Plan Duration" and "Actual Duration"..
Where,
Plan Duration: The month count of when he start to finish (sept 2011 - oct 2012; Count: 14)
Actual Duration: The month count of his actual work.. (Sept,dec,mar-oct; Count: 10)


For Actual duration it's easy for me as I've used
=COUNTIF(F87:AY87,">0")

But I'm Stuck as to how i am going to count my Plan Duration..
Is there a way where i can tell excel to lookup the First value and last value and count the months in between?

I've tried combining index & match but i guess I'm not that great to fully apply it properly..
I know it sounds complicated, but I'll really appreciate it.. Thanks in adv...

This is nice pdf but please upload excel workbook as example.

Also, please rename your title according to the rules:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

inayat, your post is against rule number 7:

7. Don't ignore requests by Administrators, Moderators, or senior members of the forum. If you are unclear about their request or instructions, then send a private message to them asking for help. Do not post a reply in a thread where such a request (e.g., title change, code tags) is pending.

inayat, try out the F5 key on a thread before you post, especially if you took a while writing your comment.

radicrains, I second zbor's request for a title change.

radicrains,

where is the data for the planned duration? The green row sums up the row below, so that is all actual, right? Where do you record the plan, then?

Try this:

=1+MAX(IF($D6:$AY6>0,COLUMN($D6:$AY6)))-MIN(IF($D6:$AY6>0,COLUMN($D6:$AY6)))

Comfirmed with ctrl+shift+enter

It's called array formula.

An array formula is a formula that works with an array, or series, of data values rather than a single data value.

Like in this example ...IF($D6:$AY6>0... it check for whole ARRAY where it's greater then 0.

To enter a formula as an array formula, type the formula in the cell and press the CTRL SHIFT and ENTER keys at the same time rather then just ENTER. You must do this the first time you enter the formula and whenever you edit the formula later. If you do this properly, Excel will display the formula enclosed in curly braces { }. You do not type in the braces -- Excel will display them automatically. If you neglect to enter the formula with CTRL SHIFT ENTER, the formula may return a #VALUE error or return an incorrect result.