date formula not working correct

  • Thread starter Thread starter Bob
  • Start date Start date
B

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))
 
Back
Top