Calendar or date formulas

  • Thread starter Thread starter Lady P
  • Start date Start date
L

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.
 
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
 
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.
Click to expand...

Sarah,

u can use EDATE(Initial Date,6)
 
Back
Top