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 ,
"Mike Metal" 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.