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