View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default Calculating Friday Date

It already does keep a Friday date

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"chris46521" wrote
in message ...

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