from daily data to weekly data

R

rutger_1

He all,

I have a list of daily data (5 days a week), but i would like to transform
this list in a list with only the data of every friday (so once a week). How
do I do this?

thanx
 
M

Marcelo

Hi, one simple way could be:

in an auxilar column use weekday function. =weedday(a2)

and filter by the result of this function friday = 6


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"rutger_1" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Day, Week or Month 1
Macros for Daily, Weekly and Monthly Reports. 4
Formula to display next Friday from B1 works except on the Friday itself. 4
Converting Daily Info to Weekly 5
Export data from the same cell from multiple spreadsheets into a n 1
Average of last 30 days 9
Converting daily data into weekly, monthly and yearly data 3
Converting daily data into weekly 1

Top