![]() |
from daily data to weekly data
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 |
from daily data to weekly data
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: 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 |
All times are GMT +1. The time now is 04:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com