If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
Try instead:
=IF(AND(DAY(TODAY()-1)=1,DAY(TODAY()-1)=6),AVERAGE(OFFSET(A536,,MATCH(TODA Y()-1,$338:$338,0)-1,,-(MATCH(TODAY()-1,$338:$338,0)-MATCH(DATE(YEAR(TODAY() -1),MONTH(TODAY()-1),1),$338:$338,0)+1))),"Formula_OR_Value_if_FALSE ") Replaced : " 19:19 " in your posted formula with: " $338:$338 " Believe the above is the main error part ... how on earth did the " 19:19 " creep into the picture ? g I've also added a phrase: "Formula_OR_Value_if_FALSE" since your posted formula was w/o this value (just change the phrase to whatever you want returned as the value if FALSE.) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Kstalker" wrote in message ... Cheers Max. I though it was as simple as that but I keep coming up with a 'false' result using the formula below..... =IF(AND(DAY(TODAY()-1)=1,DAY(TODAY()-1)=6),AVERAGE(OFFSET(A536,,MATCH(TODA Y()-1,$338:$338,0)-1,,-(MATCH(TODAY()-1,$338:$338,0)-MATCH(DATE(YEAR(TODAY() -1),MONTH(TODAY()-1),1),19:19,0)+1)))) Absoultely stumped..... -- Kstalker ------------------------------------------------------------------------ Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699 View this thread: http://www.excelforum.com/showthread...hreadid=395995 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | TC | Worksheet Functions | 1 | May 12th, 2005 02:06 AM |
Error Message - "Query is too complex" | Steve | Running & Setting Up Queries | 6 | May 6th, 2005 03:47 PM |
Using Validation to force entry into cells? | Mark | General Discussion | 16 | October 27th, 2004 09:23 PM |
Using date range in query criteria | Kathi | Running & Setting Up Queries | 4 | August 30th, 2004 03:10 PM |