Doh!
The first formula is totally obsolete, just add 29 to the date

--
Regards,

Peo Sjoblom


"Peo Sjoblom" wrote in message
...
=DATE(YEAR(A2),MONTH(A2),DAY(A2)+29)

=DATE(YEAR(A2),MONTH(A2)+3,DAY(A2))

with the date in A2


note that the second formula might yield an unexpected result for 11/30/07
(it will return 03/01/08)



--
Regards,

Peo Sjoblom




"Amanda" wrote in message
...
I'm researching a way to do the following utilizing Excel:

I need to generate several dates, based on an original date. This data
will
help our caseworkers know their upcoming deadlines.

For example: Based on the current date, which is June 04, 2007, the
Substantiation Due Date (always 29 days from the current date) would be
July
3, 2007; the Three Month Follow Up (always three months from current
date)
would be Sept. 04, 2007, etc...

What would be the best way to accomplish this?

--
Thanks!