WHAT #VALUE! MEAN

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top