Differnce between two dates

  • Thread starter Thread starter housinglad
  • Start date Start date
H

housinglad

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!
 
Sorry can you state how I would do this to dermine working days.

Cheers
Dan

Ron Coderre said:
housinglad;636895 said:
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
Click to expand...

Try something like this:
=IF(G6>0,G6-C6,"")

Is that something you can work with?


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: 1451
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=177359

Microsoft Office Help

.
Click to expand...
 
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
 
Back
Top