Thanks Ron. I have one more question.... this is for a project time sheet. I
have a column for Start Time and End Time, and I need to calculate the time
between these two. I tried just a simple J3-J2 but it didn't work.

Thanks again,
Dino




"Ron Rosenfeld" wrote in message
...
On Mon, 14 Nov 2005 12:58:18 -0500, "Dino"
wrote:

I am having trouble with a formula that calculates the weekending date
(Saturday) for a cell. For example, if I enter Nov 2 in cell B6, I want
cell
A2 to show 11/5 which is the weekending date.

Ideas?

Thanks,
Dino


=B6+7-WEEKDAY(B6)







--ron