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