Chris

=IF(WEEKDAY(s)=2,s,s-WEEKDAY(s)+2)

This is a formula I use to start a bunch of charts on a Monday. s is a
named range that is a data. I think for your purposes you could change
the 2's to 6's and the s's to the cell with the date of interest.

Good luck.

Ken
Norfolk, Va



chris46521 wrote:
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