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-
.
|