Question about this formula...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BVHis - 12 Dec 2005 20:52 GMT

=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

Signature

BVHis

Reply to this Message

Gord Dibben - 12 Dec 2005 22:00 GMT

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

>=7*(MID(CELL(\"FILENAME\"),FIND(\"]\",CELL(\"FILENAME\"))+1,255))+DATE(YEAR!A1,1,3)-WEEKDAY(DATE(YEAR!A1,1,3))
>
[quoted text clipped - 12 lines]
>
>Matt W

Reply to this Message

BVHis - 13 Dec 2005 14:26 GMT

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

Reply to this Message