#1
|
|||
|
|||
Adding months to a Date
I have found the following piece of code on the Internet and used it fine on my previous computer. Now that I changed computer, I cannot get it to work. I have not found anything relating to this in past threads in this forum.
The Idea is to add 36 (Delay) months to a date entered (StartDate). The code is: {QUOTE {SET mm{=MOD(ABS({StartDate \@ M}+Delay+11);12)}} {SET yy{=INT({StartDate \@ yyyy}+(Delay+{StartDate \@ m}-1)/12)}} {SET dd{=IF(({StartDate \@ d}>28)*({mm \@ M}=2)=1;28+((MOD(yy;4)=0)+(MOD(yy;400)=0)-(MOD(yy;100)=0)); IF(({mm \@M}=4)+({mm \@ M}=6+({mm \@ M}=9)+({mm \@ M}=11)+({StartDate \@ d}>30)>1;30;{StartDate \@ d}))}} {IF{={IF{={StartDate \@ “dddd”}}=”!*” 0 1}+{IF{={StartDate \@ “MMMM”}}= “!*” 0 1}+{IF{a}=”!*” 1 0}+{IF{=Delay}=”{Delay}” 0 1}}=0 {QUOTE “{dd}-{mm}-{yy}” \@ “dddd, d MMMM yyyy”}.” “Data entry error!”}} Can anyone help me figure out what I am doing wrong? Thank you. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding Image into a excel cell and adding a hyperlink to the image | saravananiyyanar | Excel | 3 | 05-04-2011 08:31 AM |
chart with months | windseaker | Excel | 1 | 04-29-2011 11:45 PM |
Setting up recurring months to skip some months etc. | dwelch@ykfireprevention.c | Outlook | 0 | 11-30-2010 10:15 AM |
new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
Imported message date change to today's date | promark | Outlook | 1 | 12-23-2005 07:21 AM |