Thread: Determine next Saturday based on a given date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Determine next Saturday based on a given date
=A1+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.


Reply With QuoteReply With Quote