find days since order date

In column A3 I have the date the part was asked for.  In G3, I have a column for days since date was asked for.  In E3, I have date part received.  

So if E3 has a value I need G3 to say received or something like that.  If E3 is blank then I need (current date - A3 date) to go in G3  (number of days).

What would this formula look like?
TomBallaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
NBVCConnect With a Mentor Commented:
Try:

=IF(E3="",Today()-A3,"Received")
0
 
tigin44Commented:
try
IF(E3="";+TODAY()-A3;"Received")
0
 
TomBallaAuthor Commented:
Can we make that where they have to put in a date in the E3 field?  As of now they could put in gibberish and it would say received.  Thanks.
0
 
tigin44Commented:
as I understand the formula I suggested doing what you want...  if not can you clarify...
0
 
NBVCConnect With a Mentor Commented:
To force a date in E3, select the cell and go to Data Validation, then select Date from the Allow drop down and enter the start/end date.  Then apply my formula to get the results in G3
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.

All Courses

From novice to tech pro — start learning today.