Automatic Update for Date

  • Thread starter Thread starter txdude1
  • Start date Start date
T

txdude1

But I want the date to only be Fridays. Each week it has the date of that
Friday & then it automatically changes the next week to that Friday. How do
I do this? If the TODAY function will do this then I need someone to explain
to me in detail how to do this.
 
Try to reply in the same thread, so other poster's suggestions can be seen by
all.

David's formula of
=TODAY()+MOD(6-WEEKDAY(TODAY()),7)

will do exactly what you want, only showing Fridays.
 

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

Formula to display next Friday from B1 works except on the Friday itself. 4
Automatic Update for Date 4
Friday date of next week.. 3
Date: Week in header 4
friday date 5
Easy question (just not for me) 2
formula for counting only Friday between to dates 8
Date question 4

Back
Top