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.