Calendar or date formulas

[Lady P]

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.

 

[Pete_UK]

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

 

[Nayab]

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)