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.
|