Changing Dates

  • Thread starter Thread starter Norgbort Machine
  • Start date Start date
N

Norgbort Machine

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.
 
In B1 =IF(A1<>"",IF(TODAY()>=A1+7,A1+7,""),"")

and drag across as far as you will ever need.

--
HTH

Bob Phillips

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

Norgbort Machine said:
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.

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
Click to expand...
=----
 
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
 
Back
Top