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.