Automatic Dates

L

lucky134me

I don't even know what to call it....Sorry.

What I want to do is...

Put an initial date in one column, and have dates automatically
calculated for 2 and 6-month increments.

For instance.... Input date 2mo Review Date 6mo Review Date


Any help would be appreciated by my co-workers and I. :D


Debra
 
D

Domenic

Is this what you're looking for?

Assuming that your input date is in cell A1:

2 Month Review

Cell B1
=IF(DAY(A1)>DAY(DATE(YEAR(A1),MONTH(A1)+3,1)-1),DATE(YEAR(A1),MONTH(A1)+3,1)
-1,DATE(YEAR(A1),MONTH(A1)+2,DAY(A1)))

6 Month Review

Cell C1
=IF(DAY(A1)>DAY(DATE(YEAR(A1),MONTH(A1)+7,1)-1),DATE(YEAR(A1),MONTH(A1)+7,1)
-1,DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)))

Hope this helps!
 
L

lucky134me

Wonderful..That's perfect.
Now...How do I make it work for the whole row/column?


Thanks again,
Debra
 
J

JMay

Domenic:
I'd like to create a UDF say SixMonthsAway()
which would take the date 5/15/04 and produce 11/15/04.
How would I do this?
TIA,
 
Top