Substituting for cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

What is the formula you are using?
--ron
 
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
 
What is the formula you are using?
--ron- Hide quoted text -

- Show quoted text -
Click to expand...

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
 
Back
Top