View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randal W. Hozeski Randal W. Hozeski is offline
external usenet poster
 
Posts: 33
Default Display Saturday's Date

Hi. looking for a bit of formula help

I am using a listbox to display dates, =NOW() and
=NOW()+7 ... +14 -21 etc. but would like to have
the list display only Saturday dates.

How can I tell Excel to display the Saturday of the
current week instead of the actual day today? Unless
it is actually Saturday. If today is Wednesday the 17th
I would like it to display Saturday the 20th.

Any help would be appreciated. Thanks -Randy-

..