date formula not working correct

[Bob]

I am having trouble with this formula for the weeking ending. If I open up
my file on sunday the week ending date still has the previous week ending

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

 

[JE McGimpsey]

one way:

=TODAY()+(7-WEEKDAY(TODAY())