Not entirely sure I follow - would help to have a variety of examples (for variety of dates), however...
Based on sample - given the repetitive nature of the index it might be wise to store 1 to 10 in a single row and then adapt output results accordingly using this as value as suffix ?
e.g.
A2:
=TEXT(A$1,"ddd")
copied to J2
A19:
=WEEKDAY(A$1,1)+5*(COUNTIF($A$2:A$2,A$2)-1)
copied to J19
Then
A3:
=CHOOSE(ROW(A3)-ROW(A$2),"V","N","LC","HV","HNV","HLC")&A$19
copied across matrix A3:J8
use of row 19 purely for demo - can be wherever simplify modify reference to $19 accordingly
Bookmarks