Thnks for the quick reply...yes i was trying to subtract the date i enter
manually (f14 )etc from todays date (c1)

Katherines formula works great

Thanks for your help



"Liketoknow" wrote:

Hi..new to worksheet formula's and could use some guidance

i have created a worksheet with a formula in an entire row to calculate days
old.The formula looks at two cells and calculates the difference...thats the
easy part..works good =(c1-f14) etc

What i would like to know is
In the remaining cells down the row (containing formula) i get 38944 as a
value.even though there is no value in one of the date rows.Is there a way to
calculate only the populated rows and leave the others blank or with "0"

thanks in advance