Adding 6 months to a date

[Terry252]

Hi

Can anyone help. I want to be able to add 6 months to a date. For instance if I have the date 01/01/2004, I want another column to say 01/07/2004, 6 months in advance.

Is there an easy way of doing this?

Thanks

Terry

 

[james_arackal]

Hi,


=a1+182.5

 

[onlyadrafter]

Hello,

One way, I'm sure its not the best (THOUGHT SO), but I can't think of anything else yet is

=DAY(C1)&"/"&MONTH(C1)+6&"/"&YEAR(C1)

Will keep thinking though!

James,

That only works for leap year!

 

[SydneyGeek]

If you have Analysis Toolpak activated, use =EDATE(CellRef,6) where CellRef is the cell containing the original date.

Denis

 

[sen_edp]

hello

try this topic

http://www.mrexcel.com/board2/viewtopic.php?t=4688&highlight=add+months

 

[Ekim]

Depending on what you are doing, the formulas presented may not give you the answer that you require. For example, if you work for a dentist or a doctor and you are scheduling the next appointment for 6 months hence, the previous formulas may give you a Saturday date (with my regional settings, 30 April 04 was a Friday. The formulas give 30 October 04, but that’s a Saturday).

You may be better off with adding 26 weeks instead of adding 6 months. The next appointment will be on the same day of the week as the previous appointment.

=A1+(7*26).

Regards,

Mike