Need Date Formula for 30-Days

[KATHWUN]

TO: MARKW

Mark, could you tweek the formula below to give me Start Date + 30-days? Or do I need something different?

=EDATE(TEXT($A2,"m-d"),IF(TODAY()>TEXT($A2,"m-d")+0,12,0))

A2 = Start Date
B2 = Start Date + 30 Days (3 mos).

TIA. . . Kath

[Mark W.]

30 days or 90 days? What does "(3 mos)" mean?

[KATHWUN]

90-days (sorry, got cross-wired), Mark.

[Mark W.]

Okay, the 2nd EDATE argument is the number of months [forward (+) or backwards (-)]. So, if I understand your request instead of...

=EDATE(TEXT($A2,"m-d"),IF(TODAY()>TEXT($A2,"m-d")+0,12,0))

...use...

=EDATE(TEXT($A2,"m-d"),IF(TODAY()>TEXT($A2,"m-d")+0,3,0))

If this isn't what you want perhaps you could provide some representative data showing 'start date' and the desired results.

[ This Message was edited by: Mark W. on 2002-05-20 16:12 ]

[KATHWUN]

That's the solution I need, Mark (minus the 2nd comma before the 3).
Thanks, Occam.
Kath

[Mark W.]

On 2002-05-20 16:18, KATHWUN wrote:
That's the solution I need, Mark (minus the 2nd comma before the 3).
Thanks, Occam.
Kath

I was making the argument pretty, bright red using an HTML tag... and somehow that comma sneaked in there!!! It was fixed at 16:12.

[KATHWUN]

Your correction actually beat my reply.
Amazing. The color coding is a great teaching device.

Yet, in the application of your formula, I discovered that I asked the WRONG question. I just want StartDate + 3-Months.
EXAMPLE: 1/2/00 + 3-mos = 4/2/00.
(We're massaging some blanked history here.)

Your formula that I sent back to you to tweek bounces off of "TODAY()".
Hoping,
Kath

[KATHWUN]

Your tutorials helped me to find it, Mark: =EDATE(startdate,3)
DONE -- Thanks.
Kath