Thread: [Solved] Adding 9 months to month end date.
View Single Post
 
Old 10-24-2018, 03:15 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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
All you need for the field code is:
{QUOTE
{SET Offset 9}
{SET mm{=MOD({MERGEFIELD Start_Date \@ MM}+MOD(Offset,12)+11,12)+1}}
{SET yy{=INT({MERGEFIELD Start_Date \@ yyyy}+({MERGEFIELD Start_Date \@ M}+Offset-1)/12)}}
{SET dd{=MAX(1,IF((mm=2),28+(MOD(yy,4)=0)+(MOD(yy,400)= 0)-(MOD(yy,100)=0),IF((mm=4)+(mm=6)+(mm=9)+(mm=11)>0, 30,31)))}}
"{dd}-{mm}-{yy}" \@ "d MMMM yyyy""}
where 'Start_Date' is the field name in your data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote