View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
nbaj2k[_38_] nbaj2k[_38_] is offline
external usenet poster
 
Posts: 1
Default Having a cell equal a specific day of the week?


I was wondering, is there code like the one from Niek that would allo
me to also pick something from 2 Fridays back, or Two Thursdays bac
and so on?

I need one cell to equal one wednesday back and the other to be
wednesdays back

This is the code for 1 Specific day back, just not sure what I woul
add to it to make it 2 specific days back (If you get what I'm saying)

=TODAY()-WEEKDAY(TODAY()-6)

Thanks,

~

--
nbaj2
-----------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...fo&userid=3648
View this thread: http://www.excelforum.com/showthread.php?threadid=56994