Hi!

This will keep the date numeric: (if you need to do further calcs)

=DATE(YEAR(EDATE(A1,1)),MONTH(EDATE(A1,1)),DAY(EDA TE(A1,1)))

This will return a TEXT string:

=TEXT(EDATE(A1,1),"dd/mm/yyyy")

Biff

"Aussie CPA" wrote in message
...
I'm wanting to use the edate function.
Does anyone know how I can convert the edate answer back into dd/mm/yyyy
in
the cell contents rather than with formatting.