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 |
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 |
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 |
All times are GMT +1. The time now is 04:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com