LinkBack URL
About LinkBacks
Badvgood 
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")
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")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks