WHAT #VALUE! MEAN

[DERBIE]

THEY GIVE ME A FORMULA IN THE BOOK <=TODAY()-E2/365>
EACH TIME I TYPE THE FORMULA IN PRESS ENTER I GOT THIS #VALUE! AS A RESULT.I
DID IT BEFORE IN THE SCHOOL THE RESULT WAS OK.IS THAT HAVE SOMETHING TO DO
WITH MY COMPUTER OR DO I MAKE A MISTAKE.
THANKS IN ADVANCE FOR YOUR ANSWER AND YOUR PRECIOUS HELP

 

[OssieMac]

Hi Derbie,

What value do you have in E2?

Your formula should be written exactly like this:-

=TODAY()-E2/365

or are you including the < and > signs like in your post?

Regards,

OssieMac