Thread
:
Convert SERIAL date back into dd/mm/yy format?
View Single Post
#
4
Ron Rosenfeld
Posts: n/a
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(ED ATE(A1,1)))
How does that formula differ from:
=EDATE(A1,1)
?????
--ron
Reply With Quote