Substituting for cell
 

I have created a function to calculate how many weeks there are in between
two dates that are chosen through a fomula. However where there is a date
that falls less than one week apart I get a #N/A error. I need a function
that can substitute everytime theres a #N/A with a date of the first start
date. I tried using =ISNA but i have no idea where to put it. (I have the
fn for calculation of weeks i just need to correct the error in END...thanks
for any advice you can give -Dave

START END WKS
2/3/2006 2/17/2006 3

PROBLEM
2/3/2006 #NA #NA

SHOULD LOOK LIKE
2/3/2006 2/3/2006 1

Substituting for cell
 

On Fri, 24 Aug 2007 11:18:02 -0700, Dave
wrote:

I have created a function to calculate how many weeks there are in between
two dates that are chosen through a fomula. However where there is a date
that falls less than one week apart I get a #N/A error. I need a function
that can substitute everytime theres a #N/A with a date of the first start
date. I tried using =ISNA but i have no idea where to put it. (I have the
fn for calculation of weeks i just need to correct the error in END...thanks
for any advice you can give -Dave

START END WKS
2/3/2006 2/17/2006 3

PROBLEM
2/3/2006 #NA #NA

SHOULD LOOK LIKE
2/3/2006 2/3/2006 1

What is the formula you are using?
--ron

Substituting for cell
 

Dave,

The lack of any of your formula makes this difficult. However the use of
ISNA can be generally describes as:-

=IF(ISNA(your_Formula),"what to see instead of #NA",your_formula)

Mike

"Dave" wrote:

I have created a function to calculate how many weeks there are in between
two dates that are chosen through a fomula. However where there is a date
that falls less than one week apart I get a #N/A error. I need a function
that can substitute everytime theres a #N/A with a date of the first start
date. I tried using =ISNA but i have no idea where to put it. (I have the
fn for calculation of weeks i just need to correct the error in END...thanks
for any advice you can give -Dave

START END WKS
2/3/2006 2/17/2006 3

PROBLEM
2/3/2006 #NA #NA

SHOULD LOOK LIKE
2/3/2006 2/3/2006 1

Substituting for cell
 

On Aug 24, 12:35 pm, Ron Rosenfeld wrote:
On Fri, 24 Aug 2007 11:18:02 -0700, Dave
wrote:





I have created a function to calculate how many weeks there are in between
two dates that are chosen through a fomula. However where there is a date
that falls less than one week apart I get a #N/A error. I need a function
that can substitute everytime theres a #N/A with a date of the first start
date. I tried using =ISNA but i have no idea where to put it. (I have the
fn for calculation of weeks i just need to correct the error in END...thanks
for any advice you can give -Dave

START END WKS
2/3/2006 2/17/2006 3

PROBLEM
2/3/2006 #NA #NA

SHOULD LOOK LIKE
2/3/2006 2/3/2006 1

What is the formula you are using?
--ron- Hide quoted text -

- Show quoted text -

Doesn't just subtracting the two dates and then dividing by 7 give you
the answer. If you want to round, just floor the number?

HTH,
Reeza