Subtract another 7 (that means another 7 days)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"nbaj2k" wrote in message
...
|
| I was wondering, is there code like the one from Niek that would allow
| me to also pick something from 2 Fridays back, or Two Thursdays back
| and so on?
|
| I need one cell to equal one wednesday back and the other to be 2
| wednesdays back
|
| This is the code for 1 Specific day back, just not sure what I would
| add to it to make it 2 specific days back (If you get what I'm saying)
|
| =TODAY()-WEEKDAY(TODAY()-6)
|
| Thanks,
|
| ~J
|
|
| --
| nbaj2k
| ------------------------------------------------------------------------
| nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
| View this thread: http://www.excelforum.com/showthread...hreadid=569940
|