Try this:

=TODAY()-WEEKDAY(TODAY()+1)

Biff

"Pete" wrote in message
...
Hi

I am looking to setup a formula that looks at the current date & from
that,
calculates & presents the previous fridays date in a cell

Can anyone advise me a formula for this?
--
TIA

Pete