So you want the number in B to change to the number of the month in C,
correct? If so, just put:
=MONTH(C2), and it will give you 1 through 12. If you want it to count
1,2,3, and start over at 1 when a new month occurs, then try:
=IF(MONTH(B2)<>MONTH(B1),A1+1)

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"shailend" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> When i place an date in the C colum the number in the B colum is added
> by 1.
> What i realy want is that the number start over again with 1 when i put
> in the next month.
>
> Like 1 to 20 inputs for the month januari en when februari comes Nr.
> starts over again with 1.
>
> Here is an screenshot of the situation:
>
> http://www.ssgi.nl/excel.gif
> I am dutch so "ALS" means "IF" in the formula:
> =ALS(C4="";"";ALS(B3="Nr.";1;B3+1))
>
> Thanks in advance.
>
>
> --
> shailend
> ------------------------------------------------------------------------
> shailend's Profile:
> http://www.excelforum.com/member.php...o&userid=30916
> View this thread: http://www.excelforum.com/showthread...hreadid=505924
>