Show a date based on today

[DJ Dusty]

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 b
involved, but just not sure how.

So:

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

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

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

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

 

[duane]

i would set up a table and name it "table" as follows

row number col 1 col2
1 1 5
2 2 4
3 3 3
4 4 2
5 5 1
6 6 0
7 7 6

and then if a10 is the date you start with

=A10+VLOOKUP(WEEKDAY(A10,1),table,2

 

[Ron Rosenfeld]

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