|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
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.
Column A, A1:A100 are dates
Column B, B1:B100 corresponding values
Formula in D1 entered as an array:
Copy across to E1 then down until you get #NUM! errors meaning the data has
Format column D as DATE and column E as GENERAL.
Will extract all Friday dates and their corresponding values.
"dlanc" > wrote in message
> Is there a way that I can convert daily time series data into weekly data
> Excel? I'd like to take 2 columns of data where column 1 is the date
> and column 2 is the value associated with that date and create a new
> 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.
|Thread||Thread Starter||Forum||Replies||Last Post|
|How do I import formmail data to a custom excel template?||cxlough41||Excel Worksheet Functions||1||July 1st 05 12:59 AM|
|Refresh Imported Data - Does the Excel file have to be open?||tinkertoy||Excel Discussion (Misc queries)||0||June 23rd 05 07:51 PM|
|Linking the data from one excel to another||mrbalaje||Excel Discussion (Misc queries)||2||June 13th 05 10:44 AM|
|Importing xml Data into Excel 2002||CMichaelAPCC||Excel Discussion (Misc queries)||0||June 9th 05 03:14 PM|
|Fan charts||Dean||Charts and Charting in Excel||7||May 30th 05 11:51 AM|