I have a list of the 12 months. At the end of each month information is
entered for the corresponding month.

I have a seperate report that picks up on the YTD information from the input
data. At the top of this report I show the date ie: Feb-2007, meaning the
report is YTD up to February.

What I would like to do is read from the original data how many months have
information in them. I thought I could use =COUNTIF(C60:N60,"<0"), it seems
to work. However, I can't figure out how to incorporate that outcome of 2
and combine it with the current year to come up with something that will
display as a date.

Thank you for any help you can send my way.

Cindy.

Hello
I entered the months into the range P1:P13 (Just type "January-2007"
into P1 and then fill down)
Then I used the following formula:
=INDEX($P$1:$P$12,COUNTA(C60:N60)+1)
If you try to use more than 12 months here, it will cause an error (so
if you want to continue for multiple years, you'll have to extend the
dates in P1:P13
If the year isn't as important, you could use the following
=INDEX($Q$1:$Q$12,MOD(COUNTA(C60:N60)+1,12))
and it will wrap around to January after december (you can always add
the year on later by using & or Concatenate)
=INDEX($Q$1:$Q$12,MOD(COUNTA(C60:N60)+1,12)) & " 2008"
I hope that helps.

On Mar 9, 3:37 pm, Jordan wrote:
I have a list of the 12 months. At the end of each month information is
entered for the corresponding month.

I have a seperate report that picks up on the YTD information from the input
data. At the top of this report I show the date ie: Feb-2007, meaning the
report is YTD up to February.

What I would like to do is read from the original data how many months have
information in them. I thought I could use =COUNTIF(C60:N60,"<0"), it seems
to work. However, I can't figure out how to incorporate that outcome of 2
and combine it with the current year to come up with something that will
display as a date.

Thank you for any help you can send my way.

Cindy.