Hello Again,
Dont' bother using my formula. Use the one suggested by Neik. If you paste
that in a cell it will always give you previous Friday.

Nice One Neik, but I dont really understand how and why it works. I know
that the 6 signifies Friday. Please explain if you dont mind

ChasAA

"nbaj2k" wrote:


I think I'm looking for more of what the first response was, not
necessarily a code, but something I can put in a sell sort of like

=TODAY()-WEEKDAY(TODAY()-6)

I'm just not sure exactly what that means and what number I have to put
in for it to equal a certain day sorry!

Could someone just explain 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