Help Excel Spread Sheet, should be simple for Knowledgable Excel guru...

[nesco1]

I have a worksheet (attached) I want to stop the days lapsed under column E and F when something is put into colunm G and return the message Updated

column c as date (package sent); column d has package rec by customer; column e days lapsed from day package sent; column f days lapsed from package rec by customer and column g date that tracking was updated in our system.

so I have the formula in e =IF(sum(C)=0,"-", Today()-C - so this will give me a "-" in the column until a date is populated and if a date is populated will count how many days lapsed. HOWEVER, I want it to stop counting when column G has been populated with a date.

Need this for my job any advice on how to make it work??? thanks,

The Houstonian, TX

Package Tracking	Customer's Name	Package Sent	Package received	Days Lapsed from package sent to Customer	Days Lapsed from package received by Customer	Date that Tracking was updated
123456789	LastName, First Name	01/15/14	01/30/14	252	237
123456789	LastName, First Name	01/16/14	01/31/14	251	236	07/15/14
123456789	LastName, First Name			-	-

<tbody>
</tbody>

 

[Andrew Poulsom]

Welcome to MrExcel.

To use the date in column G in place of TODAY:

=IF(C2="","-", IF(ISNUMBER(G2),G2,TODAY())-C2)

 

[nesco1]

Is there anyway I can have it populate Updated instead of the number of days lapsed when a date is placed in column G2?

 

[Andrew Poulsom]

Sure:

=IF(C2="","-", IF(ISNUMBER(G2),"Updated",TODAY()-C2))