Date Formula question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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" <[email protected]>
wrote in message
: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
 
Back
Top