Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Show a date based on today
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 |
#2
|
|||
|
|||
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) -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=277549 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
Today() or Date() function help | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Hiding rows based on date | Excel Worksheet Functions |