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!!!
--
DJ Dusty
------------------------------------------------------------------------
DJ Dusty's Profile:
http://www.excelforum.com/member.php...o&userid=16335
View this thread:
http://www.excelforum.com/showthread...hreadid=277549