Matt
See Bob Phillips's ite for why maybe your formula does not update when
switching tabs.
You need a cell reference inserted.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben Excel MVP
On Mon, 12 Dec 2005 14:52:45 -0600, BVHis
wrote:
=7*(MID(CELL(\"FILENAME\"),FIND(\"]\",CELL(\"FILENAME\"))+1,255))+DATE(YEAR!A1,1,3 )-WEEKDAY(DATE(YEAR!A1,1,3))
The above formula will display the date of a corresponding week number
(in this case, the name of the tab) of a particular year (Year!A1 =
2006).
The formula works, but it doesn't automatically update when switching
between tabs. Is there something I'm missing?? I'm not a whiz-kid
with formulas by ANY means - this is just something that I pieced
together based on some searches I've done.
If it helps I can post the spreadsheet.
Thanks in advance!
Matt W