Display Saturday's Date

  • Thread starter Thread starter Randal W. Hozeski
  • Start date Start date
R

Randal W. Hozeski

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-

..
 
Back
Top