formula in word document nativeutah 12/5/2008 6:06:01 PM I am pulling date field from quickbooks into a word document, so if my date in quickbooks is 12/16/08 I need the date in word to be 90 days in advance and rounded to the nearst date of the 1st or 16th so that my date would be 3/16/09 or if my date was 1/6/09 that my date will be 4/1/09 which is closer than the 16th of the month.

Re: formula in word document "macropod" <macropod[ at ]invalid.invalid> 12/5/2008 9:31:41 PM To see how to do this and just about everything else you might want to do with dates in Word, check out my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 or http://www.gmayor.com/downloads.htm#Third_party In particular, look at the item titled 'Date and Time Calculations In A Mailmerge'. Do read the document's introductory material. -- Cheers macropod [MVP - Microsoft Word] "nativeutah" <nativeutah[ at ]discussions.microsoft.com> wrote in message news:3694BE37-D66E-4800-868B-CF64A160FF09[ at ]microsoft.com... [Quoted Text] >I am pulling date field from quickbooks into a word document, so if my date > in quickbooks is 12/16/08 I need the date in word to be 90 days in advance > and rounded to the nearst date of the 1st or 16th so that my date would be > 3/16/09 or if my date was 1/6/09 that my date will be 4/1/09 which is closer > than the 16th of the month.

Re: formula in word document nativeutah 12/5/2008 10:12:00 PM I checked out your website, but it was a little to complicated for me, I am just a novice when it comes to word, I was hoping for just a quick formula and steps to implement it, sorry I wish I knew more about using the program. "macropod" wrote: [Quoted Text] > To see how to do this and just about everything else you might want to do with dates in Word, check out my Date Calc 'tutorial', at: > http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 > or > http://www.gmayor.com/downloads.htm#Third_party > In particular, look at the item titled 'Date and Time Calculations In A Mailmerge'. Do read the document's introductory material. > > -- > Cheers > macropod > [MVP - Microsoft Word] > > > "nativeutah" <nativeutah[ at ]discussions.microsoft.com> wrote in message news:3694BE37-D66E-4800-868B-CF64A160FF09[ at ]microsoft.com... > >I am pulling date field from quickbooks into a word document, so if my date > > in quickbooks is 12/16/08 I need the date in word to be 90 days in advance > > and rounded to the nearst date of the 1st or 16th so that my date would be > > 3/16/09 or if my date was 1/6/09 that my date will be 4/1/09 which is closer > > than the 16th of the month. >

Re: formula in word document "macropod" <macropod[ at ]invalid.invalid> 12/6/2008 3:37:04 AM Hi nativeutah, It can't get any simpler than what I've supplied - most date calculations in Word are very complicated - and your rounding requirements make it more so. -- Cheers macropod [MVP - Microsoft Word] "nativeutah" <nativeutah[ at ]discussions.microsoft.com> wrote in message news:635D7721-08C5-404B-90E6-CD7BB7ADA494[ at ]microsoft.com... [Quoted Text] >I checked out your website, but it was a little to complicated for me, I am > just a novice when it comes to word, I was hoping for just a quick formula > and steps to implement it, sorry I wish I knew more about using the program. > > "macropod" wrote: > >> To see how to do this and just about everything else you might want to do with dates in Word, check out my Date Calc 'tutorial', >> at: >> http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 >> or >> http://www.gmayor.com/downloads.htm#Third_party >> In particular, look at the item titled 'Date and Time Calculations In A Mailmerge'. Do read the document's introductory >> material. >> >> -- >> Cheers >> macropod >> [MVP - Microsoft Word] >> >> >> "nativeutah" <nativeutah[ at ]discussions.microsoft.com> wrote in message news:3694BE37-D66E-4800-868B-CF64A160FF09[ at ]microsoft.com... >> >I am pulling date field from quickbooks into a word document, so if my date >> > in quickbooks is 12/16/08 I need the date in word to be 90 days in advance >> > and rounded to the nearst date of the 1st or 16th so that my date would be >> > 3/16/09 or if my date was 1/6/09 that my date will be 4/1/09 which is closer >> > than the 16th of the month. >>

Re: formula in word document "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/6/2008 5:06:00 PM How do you get your data from quickbooks? Do you have to export to a delimited file format first, or what? -- Peter Jamieson http://tips.pjmsn.me.uk "nativeutah" <nativeutah[ at ]discussions.microsoft.com> wrote in message news:3694BE37-D66E-4800-868B-CF64A160FF09[ at ]microsoft.com... [Quoted Text] >I am pulling date field from quickbooks into a word document, so if my date > in quickbooks is 12/16/08 I need the date in word to be 90 days in advance > and rounded to the nearst date of the 1st or 16th so that my date would be > 3/16/09 or if my date was 1/6/09 that my date will be 4/1/09 which is > closer > than the 16th of the month.