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