If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel
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.......
|
#2
|
|||
|
|||
Excel
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 "Dawn" wrote in message ... 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....... |
#3
|
|||
|
|||
Excel
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 |
#4
|
|||
|
|||
Excel
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 "Dawn" wrote in message ... 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 |
#5
|
|||
|
|||
Excel
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! ============================================== "Dawn" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|