Thanks a lot for your help! The formula works great, but is there a way
to make so that if the date in column A falls on a Friday that it keeps
that same Friday date in column B? Only the dates that occur on other
days need to fall back to the previous Friday. Also the first cell in B
column always returns the #Value error and I can;t figure out why.
Thanks again for your help. I greatly appreciate it!


Bob Phillips Wrote:
=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



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