Search results

Dear all having an issue with the following: In cell c1, the formula is if(a1="","",a1+b1) if I copy that formula down the column of C, i get the #value! error. I looked in the help section but i dont get the answers.. any ideas? thanks

I guess a good kick in the a@# works, i just figured it out.. Thanks~

Hi Paul. can you explain how i would use it, i just cant seem to get this Thanks

thanks for the quick reply Mark, but that doesnt work. If I put +4 and the date is 08/01/06 in the DateRecieved(A2) cell, I get 08/05/06 which is a Saturday.. I need 4 workdays, weekdays, whatever (minus Saturdays and Sundays).

hi everyone Looking for a formula to satisfy the following: 4 working days from my date field DateRecieved. That is, cell B2 would have a formula that referred to A2(DateRecieved) and the result would be DateRecieved + 4 workdays. Thanks for any help!