View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
melcook1 melcook1 is offline
external usenet poster
 
Posts: 2
Default changed DOB to age, but if no DOB need cell to be empty.

I was hoping you would answer becasue it was you who wrote the formula I am
using. Now I'm confused with , do I add this to the orginal formula? If soI
am getting a error in doing so.

"Gary''s Student" wrote:

=IF(A1="","",DATEDIF())

(your material in the DATEDIF(), of course)
--
Gary''s Student - gsnu200810