looping question by columns

I want to print out the starting Date of the inventory based on inventory quantity using Macro.
Here is my explanation;
Some months don’t produce any inventory(0 or null) but other months can produce
Some inventory. I want to print out the first starting date of the inventory. So we can know
When is the first starting date for the product.
In the file examples, A- the product starts producing in Sep-10, so the result will be 9/1/2010 on D:7
B- The product starts producing in Dec_10, so the result will be 12/1/2010 on D:7

My try out;

Please Login or Register  to view this content.

Would you help me

Hello jimmymoon,

The attached workbook has a User Defined Function (UDF) called InventoryDate. This works like a worksheet formula. In cell "A4" you will see "=InventoryDate(B3:M3)". This will return the date of the first non-blank/no-zero entry in the range. Her is the code.

Please Login or Register  to view this content.