Automatic Update for Date
 

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.

Automatic Update for Date
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"txdude1" wrote:

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.

Automatic Update for Date
 

=TODAY()+7-WEEKDAY(TODAY()+1)
--
Gary''s Student - gsnu200821


"txdude1" wrote:

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.

Automatic Update for Date
 

Perhaps this

=IF(WEEKDAY(TODAY())<7, TODAY()+6-WEEKDAY(TODAY()), TODAY()+6)

Mike

"txdude1" wrote:

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.