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

=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.

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.