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