Ian,

Just set a reference to APTVBAEN.XLA in the VBIDE and you can then
programmatically use the ATP functions like

MsgBox Format(EDATE(Date, -3), "dd mmm yyyy")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"IanC" wrote in message
...
I am looking to programmatically move a date forward or back by whole
months
(i.e. 3, 6, or 9) - the sort of process carried out by Edate if used in a
formula. However, Edate doesn't seem to be available for use in VBA code.

Am I missing something or is there a different way around this.

Thanks in advance.