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

Please disregard this question, I put it into the wrong group.

Donna


"rainbowraven" wrote:

> 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

Please disregard this question. I posted it into the wrong area.

Donna

"rainbowraven" wrote:

> 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

Not only the wrong group, but the wrong math--- he is adding
a month instead of 30 days


"rainbowraven" <(E-Mail Removed)>
wrote in message
news:2AB854A1-3BFC-4D34-81F0-(E-Mail Removed)...
: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