Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-28-2011, 03:20 AM
tsindos tsindos is offline Adding months to a Date Windows 7 32bit Adding months to a Date Office 2010 32bit
Novice
Adding months to a Date
 
Join Date: Sep 2011
Posts: 3
tsindos is on a distinguished road
Unhappy 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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding months to a Date Adding Image into a excel cell and adding a hyperlink to the image saravananiyyanar Excel 3 05-04-2011 08:31 AM
Adding months to a Date 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
Adding months to a Date Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft