See if one of the functions in the "Days Of The Week And Month" section
of this page helps:

http://cpearson.com/excel/DateTimeWS.htm

In article <NEfee.1516$6E.790@newssvr33.news.prodigy.com>,
"Mike Metal" <mayankm@gmail.com> wrote:

> This gives the condition to be true if day=Friday (6). That is not what I
> need.
>
> I want to ab able to give the date of the last Friday or this Friday. I do
> remember that this was in microsoft's knowledgebase, several years back! I
> am unable to search for it.