Not sure if this should be posted here but trying!
I am new to arrays and found something to convert my daily data to weekly but now can't find it. I want to create a new series where it looks at my daily dates and gives me the date of every Friday(or another day I know I can change by using a different number).
I can then vlookup to match the data to the new date.
can anyone help out?
Bookmarks