Use a numerical merge field to subtract that number of months

macropod · #1 11-10-2015, 05:22 PM

Cross-posted at: http://answers.microsoft.com/en-us/o...6-07579e264cf2
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

MichaelSpedding · #2 11-11-2015, 03:35 AM

Hi,

thanks for your response.

Code:

{  QUOTE
{ SET Delay -{MERGEFIELD Unit_Lease_Dates_Notice6}}  
{ SET mm =MOD(ABS( {MERGEFIELD Unit_Lease_Dates8 \@ M} +Delay+11),12)+1}} 
{ SET yy {=INT( {MERGEFIELD Unit_Lease_Dates8 \@ yyyy}+(Delay+ {MERGEFIELD Unit_Lease_Dates8 \@ M}-1/12)}}  
{ SET dd {=IF(( {MERGEFIELD Unit_Lease_Dates8 \@ d}>28)*(mm=2)=1,28+((MOD(yy,4)=0)+(MOD(yy,400)=0)-(MOD(yy,100)=0)),IF((mm=4)+(mm=6)+(mm=9)+(mm=11)+( {MERGEFIELD Unit_Lease_Dates8 \@ d}>30)>1,30, {MERGEFIELD Unit_Lease_Dates8 \@ d}))  
" dd - mm - yy " \@ "d MMMM, yyyy”  }

This is what I have tried with no joy... it is bringing back 1 March, 2015 :(

What am I doing wrong?

also, apologies about cross posting, I'll play the ignorance card this time, won't happen again!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Spread whole number across specific months in a year	rkobeyer	Excel Programming	2	10-18-2014 11:46 PM
Counting Number of Months from a static date	bremen22	Excel	4	11-25-2013 11:57 AM
Converting serial number to years, months and days	hannu	Excel	6	02-14-2013 09:21 PM
Plotting Numerical and Non-numerical Data Set	Ife	Excel	0	04-23-2012 10:35 AM
Formula to subtract one month from due date field in reminder field	ghumdinger	Outlook	1	10-01-2011 12:09 AM