ExcelBanter - Dates

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

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

- - Dates (https://www.excelbanter.com/excel-discussion-misc-queries/224025-dates.html)

DaveKid

Dates

Hi, I would like to be able to produce a date which is automatically 3 months
ahead of a date in another cell. How do I do this?

Gary''s Student

Dates

With some date in A1, use:

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

--
Gary''s Student - gsnu200838

"DaveKid" wrote:

Hi, I would like to be able to produce a date which is automatically 3 months
ahead of a date in another cell. How do I do this?

DaveKid

Dates

Thanks

Thats great!

"Gary''s Student" wrote:

With some date in A1, use:

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

--
Gary''s Student - gsnu200838

"DaveKid" wrote:

Hi, I would like to be able to produce a date which is automatically 3 months
ahead of a date in another cell. How do I do this?

David Biddulph[_2_]

Dates

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
You will, of course, need to ask yourself the usual questions, such as what
date do you regard as being 3 months after November 30th.
--
David Biddulph

"DaveKid" wrote in message
...
Hi, I would like to be able to produce a date which is automatically 3
months
ahead of a date in another cell. How do I do this?

All times are GMT +1. The time now is 03:12 AM.