Thread: How to insert date continuosly onto sheets if the first sheet had been put the date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
  
Posts: 153
Default 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.
Reply With QuoteReply With Quote