![]() |
#1
|
|||
|
|||
![]()
Hi,
I am trying to enter a 'notice date' into a merge field however the software we use holds this as a numerical value in months (e.g. '6' months notice, as opposed to 'notice date 01/01/16'). What I have is: {QUOTE {SET NoticeDate{MERGEFIELD Unit_Lease_Dates8}} {SET Delay - {MERGEFIELD Unit_Lease_Dates_Notice6}} {SET mm{=MOD(ABS({NoticeDate \@ M}+Delay+11),12)+1}} {SET yy{=INT({NoticeDate \@ yyyy}+(Delay+{NoticeDate \@ M} - {MERGEFIELD Unit_Lease_Dates_Notice6}/12}} "{NoticeDate \@ D}{mm}{yy}" \@ MMMM D, YYYY} Unit_Lease_Dates8 = 1 Mar 2019 Unit_Lease_Dates_Notice6 = 6 The result that is being returned is January 3, 2015 Obviously this is incorrect (it should be 'September 1, 2018' - pretty close I think... ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rkobeyer | Excel Programming | 2 | 10-18-2014 11:46 PM |
![]() |
bremen22 | Excel | 4 | 11-25-2013 11:57 AM |
![]() |
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 |