Yes, indeed!

Thanks,

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"daddylonglegs" wrote in message ...
| Hi Niek, you can simplify that to
|
| =A1+7-WEEKDAY(A1+2,3)
|
| "Niek Otten" wrote:
|
| Or, if A1 can be a Saturday as well,
|
| =A1+IF(WEEKDAY(A1)=7,14,7)-WEEKDAY(A1)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Ann" wrote in message ...
| | If I have a date in a cell, I need to determine the date of the following
| | Saturday. For example, if I have the date of 10/8/2006 in a cell, I need the
| | function to return the date 10/14/2006.
|
|
|