Dates

[DaveKid]

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]

With some date in A1, use:

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

 

[DaveKid]

Thanks

Thats great!

With some date in A1, use:

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

 

[David Biddulph]

=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.