|
|
#7
04-30-2014, 01:34 PM
|
|||
|
|||
Well I thought we had it solved, but I guess I was too eager. Someone found a flaw and I rechecked the original. For some reason it’s not working properly. The expected result for line 21 (Student 19) should be May, but it shows up as Apr. I went back and checked the original sample and the formula
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+MOD(DATEDI F(TODAY(),DATE(YEAR(TODAY())+1,MONTH(DATEVALUE("1-"&$G23&"-"&YEAR(TODAY())))+1,0),"ym"),(12/2^($D23-1))),1),"MMM") gave the same results. Everything was fine until the date changed to 04/29/14 then the result changed from May (which was correct) to April which is wrong. It should have been May until 06/01/14 then it would change to Aug. Thanks for looking at it again and I do appreciate your time. Last edited by wmpwi; 04-30-2014 at 01:55 PM. Reason: more to say. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 complicated mail merge is possible?
|
chedlee | Mail Merge | 1 | 03-07-2014 12:29 AM |
| Complicated Formula Needed | midgetmogalle | Excel | 14 | 01-29-2014 10:26 AM |
| help with complicated formula | flyinghigher2011 | Excel | 6 | 07-30-2013 02:16 PM |
|
Formula and Table Help!
|
steveman1234 | Word Tables | 2 | 03-28-2010 06:20 PM |
| Using calculated field - WHY IS IT SO COMPLICATED? | Riorin | Word | 0 | 10-30-2009 12:20 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode