How to insert date continuosly onto sheets if the first sheet had been put the date?

[pejoi]

hello guys,
i wanna to put the recent date in the first sheet(named:Thursday)i
26/7/2012(Thursday) in cell g1. The next sheet(named Friday) will b
27/7/2012(Friday)in cell g1 also and so on..Is there any formulas t
look at? thank you

 

[zvkmpw]

i wanna to put the recent date in the first sheet(named:Thursday)is

26/7/2012(Thursday) in cell g1. The next sheet(named Friday) will be
27/7/2012(Friday)in cell g1 also and so on..Is there any formulas to
look at?

Maybe this would help, but first save the Excel file:
=TODAY()-WEEKDAY(TODAY())
+MATCH(MID(CELL("filename"),FIND("]",CELL("filename"))+1,255),
{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},0)

Explanation:

The formula
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
returns the sheet name, but it isn't defined until the file is saved.

 

[zvkmpw]

i wanna to put the recent date in the first sheet(named:Thursday)is

26/7/2012(Thursday) in cell g1. The next sheet(named Friday) will be
27/7/2012(Friday)in cell g1 also and so on.

If I understand correctly, the first sheet is always Thursday, the date is already in Thursday!G1, and the remaining six sheets should get consecutive dates after that.

If this is right, it's easy enough to put a different formula in each of the six remaining sheets, adding from one to six to Thursday!G1.

If something more complex is needed, here are some ideas you might be able to combine to meet the need.

First, the Tab name in which a cell lives can be calculated using:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
This formula is defined only after the workbook document is saved. It provides a weekday name in your case.

Next, a weekday number can be calculated from weekday name using MATCH() with an array of the weekday names.

The weekday number can be used in calculations using Thursday!G1, TODAY(), WEEKDAY(TODAY()), or whatever.