Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 04-30-2014, 01:34 PM
wmpwi wmpwi is offline Complicated formula or look-up table help Windows 7 32bit Complicated formula or look-up table help Office 2010 32bit
Novice
Complicated formula or look-up table help
 
Join Date: Apr 2014
Posts: 7
wmpwi is on a distinguished road
Question

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.
Attached Files
File Type: xlsx Revised Sample Problem.xlsx (14.9 KB, 22 views)

Last edited by wmpwi; 04-30-2014 at 01:55 PM. Reason: more to say.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated formula or look-up table help 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
Complicated formula or look-up table help 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft