'Macropod' frequently monitors these newsgroups, maybe he will comment.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Duncan McDonald wrote:
Hi Graham

Thanks for your help.

The site I was directed to is good but there appears to be a
discrepancy with the calculation of adding 'n' months. If you add n=6
to 1/12/04 the answer comes out as 30/6/05.

I agree excel would be better to use but I would prefer to avoid it if
possible


"Graham Mayor" wrote:

If this is an excel data file, it will be simpler to add another
column to the file and use it to calculate the date required.
Otherwise you are going to have to investigate the complexity of
calculated fields - see
http://www.wopr.com/cgi-bin/w3t/show...&Number=249902

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Duncan wrote:
I have a document that inputs data using mergefields. One
peice of data is a date called 'StartDate' another is
'Duration'.
Duration is in number of months and StartDate is a date.
I need to:
a) add the duration to the date + one day and output
through the document.
b) If the date is entered 'd/mm/yyyy' I want the output
date to be formatted as ie. 21st January 2004 both for the
StartDate value and the calculated date value

Any help would be appreciated