is there a formula for calculating dates 3 mos out

L

Lawrence

Here's an example

What is the formula I would use for calculating dates 3 mos. out

ex.

April 17, 2006 July 17, 2006 October, 17, 2006
 
E

Elkar

Let's say your original date is in cell A1. Use this formula:

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

Or if you want to calculate based on the current date:

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

HTH,
Elkar
 
Top