Showing Data Based Off a Date

[ioswoody]

I am wanting to get the data in cells to show in other cells based on the date in U5

Specifically

If the Date in cell U5 is 1-Apr-2019
I am wanting the data from cells K3:K5 to populate J3:J5
So in essence once we enter the quarter I want the data to populate and stay there (even when we leave the quarter)

Plus then be able to put the amount of trading days from that same quarter into cell J24 from the list over at T21:U25

While also filling U9 with what Quarter it is

Thanks in Advance!!

[Bo_Ry]

Please try

U9
=MOD(INT((MONTH(U5)-1)/3)-1,4)+1

J3 drag down
=IF(INT((ROWS(J$3:J3)+2)/3)=$U$9,K3,"")

J24
=INDEX(U22:U25,U9)