formula for fridays

[-Brian-H-]

i need help w/ a formula please...the formula needs to display the date of friday in the current sunday thru saturday week (this date would change weekly, every saturday after midnight). can this be done?? brian

[shg]

Maybe =TODAY()+ MOD(7 -WEEKDAY(TODAY()), 7) - 1

Edit: Or =TODAY() + 5 - MOD(TODAY() - 1, 7)

[-Brian-H-]

thanks for your help. both formulas give me last weeks friday. yesterday

No wait! That's right! thank you!

[daddylonglegs]

Maybe =TODAY()+ MOD(7 -WEEKDAY(TODAY()), 7) - 1

Edit: Or =TODAY() + 5 - MOD(TODAY() - 1, 7)

I'd always favour the first one, because it works irrespective of date system (1900 or 1904), but you can simplify to

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