I have a date on one column, and would like the column next to it to
autmomatically calculate 6 months on, and auto fill with that date.
I'm sure there is a formula for it, but I can't find one, or I'm entering
the wrong question into the search.
Can anyone help here?
Many Thanks in Advance.
Sarah M.

Six months is 182 days, so you could do it like this:

=A1+182

or like this:

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

assuming the date is in A1. Format the cell as a date, and then copy
the formula down.

Hope this helps.

Pete


On Jul 4, 9:56*am, Lady P <La...@discussions.microsoft.com> wrote:
> I have a date on one column, and would like the column next to it to
> autmomatically calculate 6 months on, and auto fill with that date.
> I'm sure there is a formula for it, but I can't find one, or I'm entering
> the wrong question into the search.
> Can anyone help here?
> Many Thanks in Advance.
> Sarah M.

On Jul 4, 1:56*pm, Lady P <La...@discussions.microsoft.com> wrote:
> I have a date on one column, and would like the column next to it to
> autmomatically calculate 6 months on, and auto fill with that date.
> I'm sure there is a formula for it, but I can't find one, or I'm entering
> the wrong question into the search.
> Can anyone help here?
> Many Thanks in Advance.
> Sarah M.

Sarah,

u can use EDATE(Initial Date,6)