How to get the last Friday date based on current date?

[zjianguk]

Hi everyone,

I need to work out how to get the last (or most recent) Friday date. Suppose today is 14/02/2013, then the previous date is: 08/02/2013. If today is 15/02/2013, then I just want it to be 15/02/2013 as it is Friday.

Thanks a lot for help

[daddylonglegs]

This formula will do that

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

[Dunc3142]

If you want to reference a cell that you enter a date in, just replace both Today() statements with the cell reference.

[zjianguk]

Thanks, daddylonglegs. This worked perfectly

This formula will do that

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