Solved

find days since order date

Posted on 2013-12-11
5
203 Views
Last Modified: 2013-12-11
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?
0
Comment
Question by:TomBalla
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39711478
Try:

=IF(E3="",Today()-A3,"Received")
0
 
LVL 26

Expert Comment

by:tigin44
ID: 39711494
try
IF(E3="";+TODAY()-A3;"Received")
0
 

Author Comment

by:TomBalla
ID: 39711506
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
 
LVL 26

Expert Comment

by:tigin44
ID: 39711540
as I understand the formula I suggested doing what you want...  if not can you clarify...
0
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 500 total points
ID: 39711567
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question