date formula not working correct

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Search closest day in the past from today 2
week numbers 7
MS Project 2016 - all tasks not showing in Calendar View 0
Email notifications without opening application 1
I have lost 6 months work, how can i get my file back 1
convert spreadsheet formula into VBA formula 4
counting weeks in current month. 1

Top