Create a "Week" Column - automatic?

**packlitely** · 07-22-2008, 08:38 PM

Hi,

I want to create a row for each of the 52 weeks in a year. I want the weeks to begin and end on thursdays. Is there a way to automate this so that I do not have to maunally enter in each week? I need to do this for 2008 and 2009.

For example

7/31/08 - 8/7/08
8/7/08 - 8/14/08
8/14/08 - 8/21/08
etc....

**Ron Coderre** · 07-22-2008, 09:07 PM

Perhaps something like this....

With
A1: (any date)
and
Weeks are Thursday through Wednesday...

This formula returns the Thursday date of the week containing that date:

Please Login or Register  to view this content.

and this formula returns the Thursday date of the subsequent week:

Please Login or Register  to view this content.

Copy that formula down as far as you need.

Example:
A1: 01-JAN-2008 (Tuesday)
Calculated dates:
A2: 27-DEC-2007 (Thursday)
A3: 03-JAN-2008 (Thursday)

Is that something you can work with?

**packlitely** · 07-22-2008, 09:20 PM

Thanks Ron!

Here is what I did:

Columns: Week (1-52) Week Start Date, Week End Date

For Start/End Date I used your A2+7 formula and filled down all the way through end of 2009.

I know my question was really elementary compared to others, but I really appreciate the help!

PL

**darshika** · 05-22-2014, 03:08 AM

I want to create a new column as week in which i want that date get seggregate automaticaly like from 1 jan to 7 jan it should show week 1 and so on the consecutive weeks and also monthly

**Fotis1991** · 05-22-2014, 03:14 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Create a "Week" Column - automatic?

LinkBack

Thread Tools

Display

Create a "Week" Column - automatic?

Create a "Week" Column - automatic?

Re: Create a "Week" Column - automatic?

Re: Create a "Week" Column - automatic?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions