Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to insert date continuosly onto sheets if the first sheet had been put the date?
hello guys,
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? thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert date continuosly onto sheets if the first sheet hadbeen put the date?
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert date continuosly onto sheets if the first sheet hadbeen put the date?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i insert todays date in a spread sheet just prior to print | Excel Worksheet Functions | |||
Insert Current Date on a Sheet 1 Tab | Excel Worksheet Functions | |||
how do i copy various sheets date to one sheet in the same excel . | Excel Worksheet Functions | |||
How to make sheet continuosly re-calc | Excel Programming | |||
How to insert date last saved into the sheet (not the footer) | Excel Worksheet Functions |