On Thu, 11 Nov 2004 15:47:13 -0600, DJ Dusty
wrote:


I would like a cell to be able to show a week ending date (a Friday)
based on today's date - I assume the TODAY() function would be
involved, but just not sure how.

So:

If today's date is 11/11/2004 (Thurs), then I would like the cell to
show 12/11/2004 (Friday).

If today's date is 12/11/2004 (Fri), then it should still show as
12/11/2004 (Fri).

If today's date is 13/11/2004 (Sat), then it should show the next
Friday date of 19/11/2004.

I'd be grateful for the answer - please!!!

The "general" formula would be:

=A1-WEEKDAY(A1+1)+7

So if you want it based on today, just substitute TODAY() for A1:

=TODAY()-WEEKDAY(TODAY()+1)+7


--ron