![]() |
|
#1
|
||||
|
||||
![]()
If you want 01/09/2019 from 01/03/2019 then use Paul's example -
{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+{DATE \@ M}-1)/12)}} {SET dd{=IF(({NoticeDate \@ 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)+( {NoticeDate \@ d}>30)>1,30,{NoticeDate \@ d}))}} "{dd}-{mm}-{yy}" \@ "dddd, d MMMM yyyy"} Change the final switch \@ "dddd, d MMMM yyyy" to \@ "dd/MM/yyyy" and then so you don't screw it up, use www.gmayor.com/export_field.htm to convert the text listing to fields.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#2
|
|||
|
|||
![]()
I have managed to get this to work now, thanks for the assistance!
I was trying to take away the number of months but it wasn't, for some reason, working when I 'SET Delay' to be negative but it did work when I subtracted 'Delay' within the other formulae. thanks again and sorry for the cross posting! |
![]() |
|
![]() |
||||
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 |