I want to be able to calculate how many working days there are between an
issue date and a completion date, but, if there is no completion date I want
to know how many days have been worked to date, iknow how to do this part

=networkdays(a1,if(b1="",today(),b1))

but, if there is no issue date (therefore no completion date) I want the
formulae to return 0 days as there are jobs that come through but haven't
been issued yet. at the moment the formulae returns a negative figure

Is there anyone that can help me?

I am not sure if this will help or not.

If you subtract one date (number) from another date (number) you will get
the number of days between them.

A date has a numerical value E.g. 02-04-07 = 39174
And 04-04-07 = 39176
So 39176 - 39174 = 2

So if there is no start date the number is 0.

The resulting answer is 0 - 39174 = 0
--
Thanks please help!


"stuck4once" wrote:

I want to be able to calculate how many working days there are between an
issue date and a completion date, but, if there is no completion date I want
to know how many days have been worked to date, iknow how to do this part

=networkdays(a1,if(b1="",today(),b1))

but, if there is no issue date (therefore no completion date) I want the
formulae to return 0 days as there are jobs that come through but haven't
been issued yet. at the moment the formulae returns a negative figure

Is there anyone that can help me?

Brett,

this only works if there is no issue date, but I want the formulae to
include the result if there is and issue date but no completion date as well,
e.g

Job Issue date completion date turnaround
1 01/04/07 04/04/2007 4
2 01/04/07 5 (days todate)
3 0

hope this makes sense

"Brett Fish" wrote:

I am not sure if this will help or not.

If you subtract one date (number) from another date (number) you will get
the number of days between them.

A date has a numerical value E.g. 02-04-07 = 39174
And 04-04-07 = 39176
So 39176 - 39174 = 2

So if there is no start date the number is 0.

The resulting answer is 0 - 39174 = 0
--
Thanks please help!


"stuck4once" wrote:

I want to be able to calculate how many working days there are between an
issue date and a completion date, but, if there is no completion date I want
to know how many days have been worked to date, iknow how to do this part

=networkdays(a1,if(b1="",today(),b1))

but, if there is no issue date (therefore no completion date) I want the
formulae to return 0 days as there are jobs that come through but haven't
been issued yet. at the moment the formulae returns a negative figure

Is there anyone that can help me?

=if(a1="","",networkdays(a1,if(b1="",today(),b1)))


"stuck4once" wrote:

I want to be able to calculate how many working days there are between an
issue date and a completion date, but, if there is no completion date I want
to know how many days have been worked to date, iknow how to do this part

=networkdays(a1,if(b1="",today(),b1))

but, if there is no issue date (therefore no completion date) I want the
formulae to return 0 days as there are jobs that come through but haven't
been issued yet. at the moment the formulae returns a negative figure

Is there anyone that can help me?

Thank you very much, you are a star

"Teethless mama" wrote:

=if(a1="","",networkdays(a1,if(b1="",today(),b1)))


"stuck4once" wrote:

I want to be able to calculate how many working days there are between an
issue date and a completion date, but, if there is no completion date I want
to know how many days have been worked to date, iknow how to do this part

=networkdays(a1,if(b1="",today(),b1))

but, if there is no issue date (therefore no completion date) I want the
formulae to return 0 days as there are jobs that come through but haven't
been issued yet. at the moment the formulae returns a negative figure

Is there anyone that can help me?