You didn't mention which is the Start Date and which one is end date (i.e.)
whether the start date is C6 Or G6.

If the Start Date is C6 and the End Date is G6 then use the below formula
=IF(G6="","",DATEDIF(C6,G6,"D"))

If the Start Date is G6 and the End Date is C6 then use the below formula
=IF(G6="","",DATEDIF(G6,C6,"D"))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"housinglad" wrote:

Hi

I want to dermine how mnay days there is between cell c6 and g6 if g6
contains a value, if not then i want thee code to do nothjing.

Mnay thanks