View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dandiehl
 
Posts: n/a
Default Finding the Monday date based on a different date in same week

I have a series of dates (monday through friday) in several weeks and months
throughout the year. I would like to create a corresponding column that
indicates what the Monday date during the week of the original date.

If A1 is original date of 4/14/2006, how can I extract the Monday date of
4/10/2006 into cell B1?