View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nbaj2k[_36_] nbaj2k[_36_] is offline
external usenet poster
 
Posts: 1
Default Having a cell equal a specific day of the week?


Right now in some of my spreadsheets, I have cells equal to things such
as =Today()-3 to go 3 days previous. In writing that I am actually
looking to find the previous Friday, since I will be running this on
Mondays. Is there a way to specifically call on "the previous Friday"
so that if I happen to run it on Tuesday it will still pickup last
Friday?

I'm sure its a line of code, just not sure where to look for it.

Thanks,

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=569940