You're welcome. Thanks for the feedback!

Biff

"Number_Cruncher" wrote in message
oups.com...
Wow! That works perfectly. Thanks a million.
Biff wrote:
Hi!

Assume your dates are in the range A1:A31

In B1 enter 1.

Enter this formula in B2 and copy down as needed:

=IF(MONTH(A2)=MONTH(A1),B1+1,1)

Biff