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

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

Assuming C6 is that start date:
=IF(G6="","",G6-C6)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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

anyone??

Just to clarify I want to determine the number of working days (cell C5 &
E5) only if cell E5 contains sum data.

Thanks
Dan

Not really, so what would the function be for 2007 version?

At the moment I have:

=IF(ISBLANK(G6),"",G6-E6)

But that just calculates days not working days.

Thanks
Dan

I'm curious....
How is it that a function whose only purpose is to calculate the number of
workdays
between two dates cannot help you calculate the number of workdays between
two dates?

If the NETWORKDAYS function does, in fact do what you want,
try something like this:
=IF(ISBLANK(G6),"",NETWORKDAYS(E6,G6))

Does that help?
***********
Regards,
Ron

XL2003, XL2007

"housinglad" wrote:

Not really, so what would the function be for 2007 version?

At the moment I have:

=IF(ISBLANK(G6),"",G6-E6)

But that just calculates days not working days.

Thanks
Dan