Hi

=IF(B1="",TODAY()-A1,B1-A1)

--
Regards

Roger Govier


"Drew" wrote in message
...
I am trying to create a formula that will calculate the "age" of a an
entry.
Each entry will have an open date. And eventually a closed date. I
would like
to be able to calculate the age, by comparing the open date and the
closed
date, and if their is no closed date then compare the open date to
todays
date. Thanks