I want to add 6 months to a certain date in a formula (Excel)
 

I need to calculate 6 months (for example) starting from a certain date (not
TODAY)...

I want to add 6 months to a certain date in a formula (Excel)
 

One way.
With starting date in A1, try this:

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Joana" wrote in message
...
I need to calculate 6 months (for example) starting from a certain date (not
TODAY)...

I want to add 6 months to a certain date in a formula (Excel)
 

=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))

this caters for 31st March not returning 1st October but 30th September.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Joana" wrote in message
...
I need to calculate 6 months (for example) starting from a certain date
(not
TODAY)...

I want to add 6 months to a certain date in a formula (Excel)
 

Now ... why didn't I think of that?<g
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Bob Phillips" wrote in message
...
=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))

this caters for 31st March not returning 1st October but 30th September.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Joana" wrote in message
...
I need to calculate 6 months (for example) starting from a certain date
(not
TODAY)...

I want to add 6 months to a certain date in a formula (Excel)
 

On Thu, 6 Jul 2006 11:27:08 +0100, "Bob Phillips"
wrote:

=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )

Verry nice. Finally, a concise substitute for the EDATE ATP function.
--ron