View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Wed, 28 Sep 2005 19:29:01 -0700, "Aussie CPA"
wrote:

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.


I'm not sure exactly what you mean, but perhaps:

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


--ron