Excel values based on consecutive dates

[gideone]

I am trying to calculate values based on consecutive dates dates. The dates are ordered in the list.

I am including a Excel 2010 file to demonstrate. I have the dates in column A, and want to calculate the values in column B.



Regards

[Pete_UK]

You can use this formula in B2:

=IF(A2="","",IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,B1))

then copy down to the bottom of your list of dates.

Hope this helps.

Pete

[gideone]

Hi Pete, thank you perfect.

What if I have different years? I've tried adapting you formula, but I have no success.


Regards

[JeteMc]

The following formula yields the same values as those manually placed in column C:

Please Login or Register  to view this content.

Let us know if you have any questions.