I need to figure out a formula that will add 30 days to a month/day/ date but
return the year as 2007 if the date is before 2007 and just add 30 days if
it's a date after the today format.

clear as mud, 'eh .... maybe this would be easier ... (see below)

ColumnA B
is: would need to return

3/15/2002 4/15/2007
3/18/1998 4/18/2007
3/20/2006 4/20/2007
3/21/2007 4/21/2007
6/28/2008 7/28/2008
4/1/2003 5/1/2007
4/1/2010 5/1/2010

and so on, the dates in column A vary, and I have no problem adding the
extra 30 days, but it's the year that's throwing me .... any suggestions?

Donna