View Single Post
  #1   Report Post  
dlanc
 
Posts: n/a
Default Daily data to weekly data conversion in Excel?

Is there a way that I can convert daily time series data into weekly data in
Excel? I'd like to take 2 columns of data where column 1 is the date (M-F)
and column 2 is the value associated with that date and create a new column
that has only the Fri dates and the values associated with the Fri dates.
I'd like to similarly further convert the end-of-week data to end-of-month
data. Thank you.