ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/155152-formula.html)

VAP

Formula

I am enter a date in a cell and in another cell i would like to input a
formula that will add or substract 6 months or more from the orginal date
cell?

JE McGimpsey

Formula

One way:

A1: <date
A2: =DATE(YEAR(A1),MONTH(A1)-6,DAY(A1))

Note that months are squirrely concepts...

In article ,
VAP wrote:

I am enter a date in a cell and in another cell i would like to input a
formula that will add or substract 6 months or more from the orginal date
cell?

Gary''s Student

Formula

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

--
Gary''s Student - gsnu200738

"VAP" wrote:

I am enter a date in a cell and in another cell i would like to input a
formula that will add or substract 6 months or more from the orginal date
cell?

All times are GMT +1. The time now is 07:42 AM.