=DATE(YEAR(EDATE(A1,1)),MONTH(EDATE(A1,1)),DAY(ED ATE(A1,1)))
How does that formula differ from:
=EDATE(A1,1)
It doesn't as far as the value returned.
The longer redundant formula will return the auto formatted value versus
Edate returning the serial date. I wasn't sure about what the OP was really
asking for. I read that maybe for some reason they couldn't format the
result of Edate. That's why I also included the Text function.
Biff
"Ron Rosenfeld" wrote in message
...
On Wed, 28 Sep 2005 22:46:31 -0400, "Biff" wrote:
Hi!
This will keep the date numeric: (if you need to do further calcs)
=DATE(YEAR(EDATE(A1,1)),MONTH(EDATE(A1,1)),DAY(E DATE(A1,1)))
How does that formula differ from:
=EDATE(A1,1)
?????
--ron
|