Changing Dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Norgbort Machine - 25 Sep 2006 07:31 GMT

I am trying to figure out a way to auto-roll the dates on a
spreadsheet forward. Basically, what I have is this:

A1 B1 C1 D1

09/25 10/01 10/08 10/15

etc...

And what I want is for those dates to all roll-forward as they are
surpassed, so that on 09/26, the dates will increment one week and
show:

10/01 10/08 10/15 10/22

etc, forever.

I appreciate any help in sorting this out.

Reply to this Message

Bob Phillips - 25 Sep 2006 08:37 GMT

In B1 =IF(A1<>"",IF(TODAY()>=A1+7,A1+7,""),"")

and drag across as far as you will ever need.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I am trying to figure out a way to auto-roll the dates on a
> spreadsheet forward. Basically, what I have is this:
[quoted text clipped - 18 lines]
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Reply to this Message

Roger Govier - 25 Sep 2006 09:00 GMT

Hi

Surely you mean on the 25 Sep 2006 they have to roll forward.
To maintain 7 day intervals, then it would be 24 Sep, 01 Oct, 8 Oct etc.

If do, in A1 enter
=DATE(2006,1,1)+WEEKNUM(TODAY())*7

In B1 enter =A1+7 and drag across as far as required

In order to use Weeknum the Analysis Toolpak must be loaded
Tools>Addins>Analysis Toolpak

Signature

Regards

Roger Govier

>I am trying to figure out a way to auto-roll the dates on a
> spreadsheet forward. Basically, what I have is this:
[quoted text clipped - 21 lines]
> ----= East and West-Coast Server Farms - Total Privacy via Encryption
> =----

Reply to this Message

Rate this thread: