PS.
I think the coded version was easier !!!!!!

Chas

"ChasAA" wrote:

Try this formula.
It will look up the previous Friday from the date you enter in Cell A1

=IF(TEXT(A1-1,"dddd")="Friday",A1-1,IF(TEXT(A1-2,"dddd")="Friday",A1-2,IF(TEXT(A1-3,"dddd")="Friday",A1-3,IF(TEXT(A1-4,"dddd")="Friday",A1-4,IF(TEXT(A1-5,"dddd")="Friday",A1-5,IF(TEXT(A1-6,"dddd")="Friday",A1-6))))))

Good Luck

Chas
PS Itried it and IT does work!!

"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