Display month where only one month is in a range or display "YTD" if several months are...

Hello All,

In a column, I have a range of dates. Sometimes the dates will be all in one month (January) and other times it will contain dates from multiple months.

I would like a formula that looks at this range and if the data is all for one month, displays the month name (January) but where the data covers several months it displays "YTD".

Any ideas on how to do it, please?

Thanks

You're implying there are no blanks between any dates, is that correct?

What happens if it's the same month, but a different year? What do you want then?

Assuming you know the last occupied cell, e.g. A10, or how far down the data will fill.
This will ignore blanks as well.

=SUMPRODUCT(((MONTH(A1:A10)<>MONTH(A1))+(YEAR(A1:A10)<>YEAR(A1)))*(A1:A10<>0))

There are no dates outside of January 2019 in that range, hence the zero.

Ok

this works

=IF(SUMPRODUCT(((MONTH(A2:A358)<>MONTH(A2))+(YEAR(A2:A358)<>YEAR(A2)))*(A2:A358<>0))=0,TEXT(A2,"mmmm"),"YTD")