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

nesco1

New Member
Joined
Sep 24, 2014
Messages
2
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 TrackingCustomer's Name
Package SentPackage receivedDays Lapsed from package sent to CustomerDays Lapsed from package received by CustomerDate that Tracking was updated
123456789LastName, First Name01/15/1401/30/14252237
123456789LastName, First Name01/16/1401/31/1425123607/15/14
123456789LastName, First Name--

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to MrExcel.

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

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

nesco1

New Member
Joined
Sep 24, 2014
Messages
2
Is there anyway I can have it populate Updated instead of the number of days lapsed when a date is placed in column G2?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top