Date Arithmetic Q

[Applewine]

My project involves setting evaluation dates from a hir
date...evaluations would begin in the first 3 months, then every
months thereafter.

The problem is, I cannot just add 90 days to get the evaluation date
as that changes lets say, 1/5/04 to 4/3/04...I need it instead to sho
1/5/04 to 4/5/04.

The Datedif function gives inaccurate results (at least, as I've use
it)...any other ideas to roll the month ONLY forward 3 units

 

[Bob Phillips]

Try adding months like so

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

This is fine as long as you're not dealing in month ends, as some months
could have a day 31, but 3 months forward doesn't

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[PegL]

You could use the EDate function (in Analysis Toolpak).

 

[Applewine]

Your solution was right on!
I got so enamoured of more complex functions that I missed that very
simple straightforward approach...kudos!