Complicated formula or look-up table help

wmpwi · #5 04-18-2014, 05:27 AM

Quote:

Originally Posted by macropod

From what you've described, I believe you can use:
=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")<snip> needed.

Thanks.

This may solve many a problem (for me anyway). I'll start playing with it this morning and feed back once I'm sure I haven't screwed something up.

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