Add date range

  • Thread starter Thread starter Jonas Trevellion
  • Start date Start date
J

Jonas Trevellion

I'd like to add a column to my spreadsheet that includes a range of dates by
week, i.e.

COLUMN A
Week
16/02/09 - 22/02/09
09/02/09 - 15/02/09
02/02/09 - 08/02/09
26/01/09 - 01/01/09
etc

COLUMN B
Week Number
8
7
6
5
etc

Is there a function to do this automatically? I'm using Excel 2007 SP3
 
Hi Max,

He's using 2007, he doesn't need to install the Analysis ToolPak for the
functions. Those are now all incorporated in Excel proper. You only need to
attach the ATP if you are going to use the Data Analysis Tools.
 
Hi,

I favor Max's idea of splitting the dates into two columns, however, here is
the formula to do what you wish with your data as is:

=WEEKNUM(LEFT(A1,FIND("-",A1)-1))

Warning: WEEKNUM is handled differently in different countries for that
reason this function has a second argument not shown here. You should check
the Help system to see which applies to your situation.
 
select a cell in column B and enter following formula in formula bar

=MID(A1,1,FIND("-",A1,1)-2)

Note: you need excel 2007 because it won't work in excel 2003


Chris
 

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

Back
Top