In that case, Aflatoon's solution will work but it needs to be put into a single cell (no CSE (array-entering) required) and copied down. See cells B16:B19 in Sheet1 of the attached.
Separately, sheet Sheet1 PQ contains a Power Query solution, but it's ugly and I would NOT recommend using it (it loses the date values in the header row).
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote
