Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 04-30-2014, 03:45 PM
macropod's Avatar
macropod macropod is offline Complicated formula or look-up table help Windows 7 32bit Complicated formula or look-up table help Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In F3, try:
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+MOD(DATEDI F(DATE(YEAR(TODAY()),MONTH(TODAY()),1),DATE(YEAR(T ODAY())+1,MONTH(DATEVALUE("1-"&$E3&"-"&YEAR(TODAY())))+1,0),"ym"),(12/2^($D3-1))),1),"MMM")
then copy down as far as needed.

PS: As previously advised, the board software puts spaces in the formula where there shouldn't be any. In this case, 'DATEFI F' is 'DATEDIF' and 'T ODAY()' is 'TODAY()'

Note: If you change the cell format, to 'mmm', you could reduce the formula to:
=DATE(YEAR(TODAY()),MONTH(TODAY())+MOD(DATEDIF(DAT E(YEAR(TODAY()),MONTH(TODAY()),1),DATE(YEAR(TODAY( ))+1,MONTH(DATEVALUE("1-"&$E3&"-"&YEAR(TODAY())))+1,0),"ym"),(12/2^($D3-1))),1)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Thread Tools
Display Modes


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 12:50 PM.


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