tmaususer
asked on
Help with a simple data calculation ms excel 2003
I am fairly new to excel and cannot figure out a simple date calculation in regards to a result I am getting. I am dealing with two cells. Cell a1 has a heading of date. Cell b1 has a heading of days. So in cell a2 I place a date of say 3/1/12. In cell b2 I have a simple formula of
=today()-a2. This returns a result of 21 which is correct. But if I remove the date my days change to 40990. Is there a way (and if so how) to remove the data and show no results in b2 until a date is actually entered in a2?
=today()-a2. This returns a result of 21 which is correct. But if I remove the date my days change to 40990. Is there a way (and if so how) to remove the data and show no results in b2 until a date is actually entered in a2?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.