I need a formula which inserts either the date in a cell when the file is opened or the week ending date... can anyone help?
Hi David, 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 Do read the document's introductory material. -- Cheers macropod [MVP - Microsoft Word] "david24" wrote in message news:404ED4CE-B933-4B90-A667-D1DA89E427D9@microsoft.com... >I need a formula which inserts either the date in a cell when the file is > opened or the week ending date... can anyone help?
Its not what i am after, i just need a formula for both. "macropod" wrote: > Hi David, > > 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 > > Do read the document's introductory material. > > -- > Cheers > macropod > [MVP - Microsoft Word] > > > "david24" wrote in message news:404ED4CE-B933-4B90-A667-D1DA89E427D9@microsoft.com... > >I need a formula which inserts either the date in a cell when the file is > > opened or the week ending date... can anyone help? > >
A formula *is* a field. Are you asking for a macro? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "david24" wrote in message news:E3C41F09-52AE-473A-A80A-9A205667995A@microsoft.com... > Its not what i am after, i just need a formula for both. > > "macropod" wrote: > >> Hi David, >> >> 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 >> >> Do read the document's introductory material. >> >> -- >> Cheers >> macropod >> [MVP - Microsoft Word] >> >> >> "david24" wrote in message >> news:404ED4CE-B933-4B90-A667-D1DA89E427D9@microsoft.com... >> >I need a formula which inserts either the date in a cell when the file >> >is >> > opened or the week ending date... can anyone help? >> >>
Sorry it was a macro but i have it now! "Suzanne S. Barnhill" wrote: > A formula *is* a field. Are you asking for a macro? > > -- > Suzanne S. Barnhill > Microsoft MVP (Word) > Words into Type > Fairhope, Alabama USA > > "david24" wrote in message > news:E3C41F09-52AE-473A-A80A-9A205667995A@microsoft.com... > > Its not what i am after, i just need a formula for both. > > > > "macropod" wrote: > > > >> Hi David, > >> > >> 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 > >> > >> Do read the document's introductory material. > >> > >> -- > >> Cheers > >> macropod > >> [MVP - Microsoft Word] > >> > >> > >> "david24" wrote in message > >> news:404ED4CE-B933-4B90-A667-D1DA89E427D9@microsoft.com... > >> >I need a formula which inserts either the date in a cell when the file > >> >is > >> > opened or the week ending date... can anyone help? > >> > >> > > >
