![]() |
#7
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |