=A1-CHOOSE(WEEKDAY(A1),2,3,4,5,6,0,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"chris46521" wrote
in message ...

I have dates listed in column A indicating the day an action was
performed. In column B I need to have the date in column A changed to a
Friday. If the date in column A is not a Friday, then the date in column
B needs to fall back to the previous Friday. For example, if the date
entered in column A is today, Monday August 7, then the date in column
B that I would be Friday August 4. Can anyone think of code (or a
formula) that can determine this and place the value in column B?
Currently I use vlookup to go to another sheet where all the possible
dates are listed with their respective Fridays, but this slows down the
calculation worksheet as the file is quite large. Thanks for any help or
suggestions.


--
chris46521
------------------------------------------------------------------------
chris46521's Profile:
http://www.excelforum.com/member.php...o&userid=35909
View this thread: http://www.excelforum.com/showthread...hreadid=569090