Thread: Age calculation
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
lsmft
 
Posts: n/a
Default Age calculation


Hello,
I can get the Ardus Petus to work very well, but I can't seem to get
the David formula ...DATEDIF(A1, TODAY(), "y")... to work. It looks
like there may be a space between the ..first comma and today... and
also a space between the ...second comma and the first quotation
mark...
Irregardless, I can't get it to work with or without a space.
I have tried formating my formula cell to TEXT, then to NUMBER, and
then to GENERAL.
I can't get it to go.
I also have put an equal sign at the first and that didn't help. Could
the formula be incorrect or am I doing something wrong?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=523477