Excel

[Dawn]

I have created a basic workbook that I have 31 worksheets in. I would like to type Monday June 7, 2004 and on each subsquent worksheet it change to the current date such as second worksheet would say Tuesday, June 8, 2004 and the third worksheet would say Wednesday, June 9, 2004 and so forth. Does anyone know if this is possible and if so how would I go about doing it. Please keep it simple.......

 

[CLR]

Assuming your date is in A1 of Sheet1, then in A1 of sheet2 put =Sheet1!a1+1
and in A1 of Sheet2 put =Sheet1!a1+2 etc etc..........

Vaya con Dios,
Chuck, CABGx3

I have created a basic workbook that I have 31 worksheets in. I would

like to type Monday June 7, 2004 and on each subsquent worksheet it change
to the current date such as second worksheet would say Tuesday, June 8, 2004
and the third worksheet would say Wednesday, June 9, 2004 and so forth.
Does anyone know if this is possible and if so how would I go about doing
it. Please keep it simple.......

 

[Dawn]

----- CLR wrote: ----

Assuming your date is in A1 of Sheet1, then in A1 of sheet2 put =Sheet1!a1+
and in A1 of Sheet2 put =Sheet1!a1+2 etc etc.........

Vaya con Dios
Chuck, CABGx


Thank you so much. I have spent the last two days trying to figure this out

I have created a basic workbook that I have 31 worksheets in. I woul

like to type Monday June 7, 2004 and on each subsquent worksheet it chang
to the current date such as second worksheet would say Tuesday, June 8, 200
and the third worksheet would say Wednesday, June 9, 2004 and so forth
Does anyone know if this is possible and if so how would I go about doin
it. Please keep it simple......

 

[Dawn]

Chuck

One more thing.....I figured out part of the formula but am still having some problems that maybe you can help me with...

I have formatted my date to look like this - - 01-June-04 and used the following formula ='1'!A2+1 and it will add one to each subsquent page but whenever I use a date such as this - Tuesday, June 1, 2004 the above formula will not work. It will just error out. Do you suggest that I move my actual day to another cell or do you have anymore suggestions as to what I can do in order for my date to take as I wanted it to (Tuesday, June 1, 2004)

My data is in A2

 

[CLR]

Hi Dawn.............

It doesn't matter which cell you use on the subsequent sheets, as long as
your foumula reads Sheet1!A1+x..............it also doesn't matter which way
you have each cell formatted. Excel sees the date only as a number, and
puts that number in the cell. The formatting is only for our human eyes.
As for the "error out", you're using a format that gives you "Tuesday, June
1, 2004", it may just be simply too much for the column width you have, and
returning #########..........if that's the case, try just widening the
column...........

hth
Vaya con Dios,
Chuck, CABGx3

Chuck,

One more thing.....I figured out part of the formula but am still having

some problems that maybe you can help me with....

I have formatted my date to look like this - - 01-June-04 and used the

following formula ='1'!A2+1 and it will add one to each subsquent page but
whenever I use a date such as this - Tuesday, June 1, 2004 the above formula
will not work. It will just error out. Do you suggest that I move my
actual day to another cell or do you have anymore suggestions as to what I
can do in order for my date to take as I wanted it to (Tuesday, June 1,
2004)?

 

[RagDyer]

Just curious ... how did you get the day to display?
Did you custom format the cell <dddd, mmmm d, yyyy>
OR
Did you enter the day from the keyboard?

If you entered the day from the keyboard, and then entered the date like
this:
Tuesday, 6/1/04
You will get a #Value! error if you add one (1) to it in another cell.

Look in the formula bar.
If you see
Tuesday spelled out with the date following, there's your mistake.

A true date will not display with the day spelled out.

Enter 6/1/04 into A1 and custom format
<dddd, mmmm d, yyyy>

In B1 enter
=A1+1
And see what you get.

Now, in A1 enter Tuesday, 6/1/04
OR
Tuesday, June 1, 2004
And see what you get in B1 with the same formula.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Chuck,

One more thing.....I figured out part of the formula but am still having
some problems that maybe you can help me with....

I have formatted my date to look like this - - 01-June-04 and used the
following formula ='1'!A2+1 and it will add one to each subsquent page but
whenever I use a date such as this - Tuesday, June 1, 2004 the above formula
will not work. It will just error out. Do you suggest that I move my
actual day to another cell or do you have anymore suggestions as to what I
can do in order for my date to take as I wanted it to (Tuesday, June 1,
2004)?

My data is in A2