Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

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?
0
tmaususer
Asked:
tmaususer
1 Solution
 
Frank WhiteCommented:
=IF(A2<>"",TODAY()-A2,"")

This will only calculate the date if A2 is not blank. If it is blank, this cell remains blank.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now