Stopping Formula When Date In Another Column Is Entered

[MEL79]

How do I stop the count in one column when I enter a date in another column?

I've entered a formula in column F to count the number of days between start and end dates so I know when it goes overdue

In column G I have a column that titled date received and I would like to know what to use to stop the count in column f when I enter the date in G

[AlfD]

Hi!

Try:

=if(G1="",<your time-diff formula>,"")

It says if there's nothing in G1, show the overdue result, otherwise leave blank.

Alf