Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about this formula...
=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 -- BVHis ------------------------------------------------------------------------ BVHis's Profile: http://www.excelforum.com/member.php...fo&userid=8593 View this thread: http://www.excelforum.com/showthread...hreadid=492858 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about this formula...
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about this formula...
Thanks for the link. It helps, but I still need to do some "tweaking". I'll be sure to post back if I need any more help. Thanks again! It's very much appreciated! Matt W -- BVHis ------------------------------------------------------------------------ BVHis's Profile: http://www.excelforum.com/member.php...fo&userid=8593 View this thread: http://www.excelforum.com/showthread...hreadid=492858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question | Excel Worksheet Functions | |||
Formula question | Excel Discussion (Misc queries) | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
An Excel Formula Question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) |