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-

..

Display Saturday's Date
 

Try this

=NOW()+7-WEEKDAY(NOW())


"Randal W. Hozeski" wrote in message
news:c92Eb.576626$Tr4.1551609@attbi_s03...
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-

.

Display Saturday's Date
 

Thanks Mike
Worked great!! -Randy-



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!