Thread: Formula to Create Consecutive #s for Non-Linear Dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Number_Cruncher Number_Cruncher is offline
external usenet poster
  
Posts: 5
Default Formula to Create Consecutive #s for Non-Linear Dates
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

Reply With QuoteReply With Quote